Convert Degree minutes and second lat and long to decimasl

Sophie_E

New Member
Joined
Jun 11, 2013
Messages
1
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]
 
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
 
Last edited:
Upvote 0
If A1 contains degrees and B1 contains minutes & C1 contains seconds, then in D1 enter the formula:

=A1+B1/60+C1/3600
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top