Calculate distance and time between two addresses using google maps

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,647
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:

Forum statistics

Threads
1,082,557
Messages
5,366,304
Members
400,882
Latest member
zaldy_a

Some videos you may like

This Week's Hot Topics

Top