convert latitude and longtitude minutes, seconds into latitude dec

M

MethowNative

how to convert latitiude and longitude minutes and seconds to latitude and
longitude decimal degrees in excel or access.
 
J

John Vinson

how to convert latitiude and longitude minutes and seconds to latitude and
longitude decimal degrees in excel or access.
Click to expand...

How are the d.m.s values stored? In one text field, or (better) three
integer fields? If the latter:

[Deg] + Sign([Deg]) * [Min] / 60 + Sign([Deg]) * [sec] / 3600

If it's one text field like 116°56'48" then you'll need to parse out
the numbers.

John W. Vinson[MVP]
 
Top