G Guest Apr 28, 2006 #1 i have a column of info in degrees/min/sec example: 254802N 0503311E How or can vert this column to decimal degrees?
i have a column of info in degrees/min/sec example: 254802N 0503311E How or can vert this column to decimal degrees?
G Guest Apr 28, 2006 #2 Help us to help you. Is 254802 25 degrees - 48 minutes - 02 seconds That is can we assume that the first angle only goes to 90?
Help us to help you. Is 254802 25 degrees - 48 minutes - 02 seconds That is can we assume that the first angle only goes to 90?
J JE McGimpsey Apr 28, 2006 #3 One way: Latitude: =TEXT(TEXT(LEFT(A1,6),"00\:00\:00")*24,"00.0000")&MID(A1,7,1) Longitude: =TEXT(TEXT(MID(A1,9,7),"00\:00\:00")*24,"000.0000")&RIGHT(A1,1) Change the "00.0000" and "000.0000" to reflect the number of decimal places you want to display.
One way: Latitude: =TEXT(TEXT(LEFT(A1,6),"00\:00\:00")*24,"00.0000")&MID(A1,7,1) Longitude: =TEXT(TEXT(MID(A1,9,7),"00\:00\:00")*24,"000.0000")&RIGHT(A1,1) Change the "00.0000" and "000.0000" to reflect the number of decimal places you want to display.
