Convert Degree minutes and second lat and long to decimasl

[Sophie_E]

Hi, I'm trying to convert degree minutes and second latitude and longitude to decimal lat and long in excel (I have 100s of such conversion to undertake). When trying out dividing the minutes and second by 60 and checking my calculation on Google Maps lat/long finder or Latlong.net my calculations are not correct. However the equation to other way around - converting from decimal lat long to DMS (*60) works. Can anyone help?

Thanks

Sophie
[TABLE="width: 103"]
<colgroup><col></colgroup><tbody>[TR]

[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[hiker95]

Sophie_E,

Welcome to the MrExcel forum.

See if something below will assist you:

convert some latitude and longitude coordinates from "Degrees, Decimal Minutes" format to "Decimal Degrees" format
How to convert degrees/minutes/seconds angles to or from decimal angles in Excel 2000

How to get lat/long coordintates with VBA Excel

How to find your latitude and longitude

Finding the location of a non-US city
Here are some sites that have the locations of major cities in the world.
Latitude-Longitude of World Cities ([url]www.realestate3d.com)[/url]
Latitude and Longitude of World Cities (London, L.A., Paris, Singapore) | Infoplease.com

Try this udf it will help you in finding the time and distance between two cities using Google Map
Ashish Koul
Excel VBA Codes & Macros

Getting LAT and LONG from address
Getting LAT and LONG from address - Page 2Quick and easy geocoding for Tableau | Tableau Love

A Free Zip Code Database + Latitude and Longitude
Free Zipcode Database | Free Zip Code Database

 

[Gary's Student]

If A1 contains degrees and B1 contains minutes & C1 contains seconds, then in D1 enter the formula:

=A1+B1/60+C1/3600