software

i have a column of info in degrees/min/sec
example: 254802N 0503311E

How or can vert this column to decimal degrees?

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?

--
Gary''s Studentquot;Chrissyquot; wrote:

gt; i have a column of info in degrees/min/sec
gt; example: 254802N 0503311E
gt;
gt; How or can vert this column to decimal degrees?

One way:

Latitude:

=TEXT(TEXT(LEFT(A1,6),quot;00\:00\:00quot;)*24,quot;00.0000quot;)amp; MID(A1,7,1)

Longitude:

=TEXT(TEXT(MID(A1,9,7),quot;00\:00\:00quot;)*24,quot;000.0000quot; )amp;RIGHT(A1,1)

Change the quot;00.0000quot; and quot;000.0000quot; to reflect the number of decimal
places you want to display.

In article gt;,
Chrissy gt; wrote:

gt; i have a column of info in degrees/min/sec
gt; example: 254802N 0503311E
gt;
gt; How or can vert this column to decimal degrees?