MrExcel Publishing
Your One Stop for Excel Tips & Solutions

converting decimal degrees to D:M:S


Posted by Tracer on January 24, 2002 1:45 PM

Does anyone know how to convert decimal degrees to degrees-minutes-seconds in excel?


Posted by Barrie Davidson on January 24, 2002 2:47 PM

Please refresh my memory. How many seconds in a minute (is it 60 like time)? How my minutes in a degree?

BarrieBarrie Davidson

Posted by Dave Gibson on January 25, 2002 7:03 AM

You can create a couple of formulas to do the conversion. If you decimal value is in A1 the put this formula in cell B2; TRUNC(A1,0). This gets the degress portion of the value. Next, put this formula in cell A2; (A1-B1)*60. This converts the remainder to decimel minutes. Next, put this formula in cell B2; TRUNC(B2). This gets the whole number portion of the minutes. Next put this formula in cell B3; (A2-B2)*60. This converts the remainder to decimel seconds. The result in cells B1, B2, and B3 are Degrees, Minutes and Seconds, repsectively from a decimal value entered in cell A1.

Posted by Tracer on January 25, 2002 9:01 AM

Yes there are 60 in each
Tracer

Posted by Barrie Davidson on January 25, 2002 9:19 AM

Please see Dave's response (nt)