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)
