convert latitude and longtitude minutes, seconds into latitude dec

G

Guest

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS Access vba AfterUpdate coding question (hopefully a simple fix!) 0
translate degrees to latitude longitude 3
How do I show Latitude and Longitude in Excel Table 1
degrees decimal minutes format for latitude longitude 2
Formatting columns for Lat-Long 9
What data type should I use to store latitude and longitude? 10
Copying calculated values into existing fields 2
Taking lines from multiple files into one sheet 1

Top