Calculate distance and time between two addresses using google maps

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
Ajw43022,

The security settings on my PC will not allow me to download the workbook from the site you provided.

Maybe 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
http://support.microsoft.com/kb/213449

How to get lat/long coordintates with VBA Excel
http://www.mapforums.com/how-get-lat-long-coordintates-vba-excel-7094.html

Resources for determining your latitude and longitude
http://jan.ucc.nau.edu/~cvm/latlon_find_location.html

Finding the location of a non-US city
Here are some sites that have the locations of major cities in the world.
http://www.realestate3d.com/gps/world-latlong.htm
http://www.infoplease.com/ipa/A0001769.html

Getting LAT and LONG from address
http://www.mrexcel.com/forum/showthread.php?t=619691&page=2

http://tableaulove.tumblr.com/post/9290566377/quick-and-easy-geocoding-for-tableau

A Free Zip Code Database + Latitude and Longitude
http://federalgovernmentzipcodes.us/
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,102,305
Messages
5,486,072
Members
407,532
Latest member
shahbazfcca

This Week's Hot Topics

Top