S
Selchie
Hello... I am new here and am looking for some advise on a formula for
Latitude and Longitude. I am using Excel 97 and I am making a sea log
for my husband. I have figured out how to change metric Lat/Long (DDD)
into normal Lat/Long (DMS = degree, minutes, seconds).
A metric Lat/Long reading would look like this:
48.367123 by 124.6112.
The normal reading most people are accustom to seeing looks like this:
48°22'02" by 124°36'44".
In order to make Excel change the metric reading into DMS first you
have to divide the metric reading by 24, that coding would be =(A1/24).
I got that to work fine. Then you have to Custom format your cells to
show:
[h]°mm'ss\"
I got that to work just fine also. My readings show as the DMS such as
48°22'02" which is what I want.
My problem is that I need the seconds portion to read in the
hundredths... three number places (.000) not just two number places
(.00). I can't figure out the formula for this and I haven't been able
to find it anywhere on the Internet either. If I try adding another
"s" to the second portion of the formula, I still only get two number
places... (.00) it won't add the third place. If I try using "mmm"
instead of "sss" it gives me the month... of course as that is the
coding for a month. If I try "ddd" it gives me the day... because of
the day coding.
If ANYONE knows how to do this or can help me with this I sure would
appreciate it... it's driving me nuts
Thank you... you have a great forum here
Selchie
Latitude and Longitude. I am using Excel 97 and I am making a sea log
for my husband. I have figured out how to change metric Lat/Long (DDD)
into normal Lat/Long (DMS = degree, minutes, seconds).
A metric Lat/Long reading would look like this:
48.367123 by 124.6112.
The normal reading most people are accustom to seeing looks like this:
48°22'02" by 124°36'44".
In order to make Excel change the metric reading into DMS first you
have to divide the metric reading by 24, that coding would be =(A1/24).
I got that to work fine. Then you have to Custom format your cells to
show:
[h]°mm'ss\"
I got that to work just fine also. My readings show as the DMS such as
48°22'02" which is what I want.
My problem is that I need the seconds portion to read in the
hundredths... three number places (.000) not just two number places
(.00). I can't figure out the formula for this and I haven't been able
to find it anywhere on the Internet either. If I try adding another
"s" to the second portion of the formula, I still only get two number
places... (.00) it won't add the third place. If I try using "mmm"
instead of "sss" it gives me the month... of course as that is the
coding for a month. If I try "ddd" it gives me the day... because of
the day coding.
If ANYONE knows how to do this or can help me with this I sure would
appreciate it... it's driving me nuts
Thank you... you have a great forum here
Selchie