Geesh Robert...where were you last week? LOL We went ROUND AND ROUND about this and Greg figured out the fix...read it here: http://personal-computer-tutor.com/abc3/v28/greg28.htm See Greg? I just KNEW this article would come in handy here <wink> And Robert..I gotta get to bed...HUGE workday tomorrow...so I don't have time to play around with your two Excel questions...but I can DEFINITELY tell you COUNTIF ain't the way to do it...it's gonna be a combo of text functions (look thru them in the paste function wizard)...I'm sure Ray will be chiming in soon with wonderful formulas for you Nighty night Linda F. Johnson, M.A., MOS Linda's Computer Stop http://personal-computer-tutor.com Free e-Books, Newsletter, and tutorials -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Carneal Sent: Monday, September 15, 2003 10:39 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Hours Minutes Seconds?? WHERE did those =20 come from????? I did not type them in! Robert At 09:33 PM 9/15/2003, you wrote: >Is Hours Minutes Seconds the best way to enter GPS location into an >Excel=20 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************