Geographic Co-ordinate conversion....° ' and '' to ° and decimal minutes

NigelTheDrog

New Member
Joined
Aug 31, 2017
Messages
2
I need a formulae to convert degrees, minutes, seconds (and decimals - eg 55° 51' 02.3305) to degrees and decimal minutes (eg 55° 51.0388425').
I have 116 :)() lats. and longs to convert and doing them manually is taking an age and very prone to errors!
Many thanks in advance.
NigelTheDrog
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,997
I need a formulae to convert degrees, minutes, seconds (and decimals - eg 55° 51' 02.3305) to degrees and decimal minutes (eg 55° 51.0388425').
I have 116 (
) lats. and longs to convert and doing them manually is taking an age and very prone to errors!

<tbody>
</tbody>
Many thanks in advance.
NigelTheDrog
55 51 39deg min sechere you need only see what 39secs is as a dec minute39/60 =0.6555 51.65
55 51 2.3305deg min decsecshere you need only see what 2.3305 secs is as a dec minute2.3305/600.03884255 51.038842
is there more to it than this
you can tell which calculation is required by testing for the presence of a "."

<colgroup><col><col><col span="15"></colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,100,205
Messages
5,473,152
Members
406,849
Latest member
AndreasMs

This Week's Hot Topics

Top