convert latitude and longtitude minutes, seconds into latitude dec

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to convert latitiude and longitude minutes and seconds to latitude and
longitude decimal degrees in excel or access.
 
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]
 
You must log in or register to reply here.

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
What data type should I use to store latitude and longitude? 10
Navigation Questions 1
Formatting columns for Lat-Long 9
mapping from excel 2

Back
Top