convert latitude and longtitude minutes, seconds into latitude dec

convert latitude and longtitude minutes, seconds into latitude dec

Post by TWV0aG93Tm » Thu, 13 Jan 2005 10:53:09


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

convert latitude and longtitude minutes, seconds into latitude dec

Post by John Vinso » Thu, 13 Jan 2005 15:02:54

On Tue, 11 Jan 2005 17:53:09 -0800, MethowNative



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 1166'48" then you'll need to parse out
the numbers.

John W. Vinson[MVP]