Driving distance between two coordinates

22.6k views Asked by At

I have a long list of locations in excel format and I need to calculate driving distance between these locations using lat&long. Is there any macro I can use. Cheers

1

There are 1 answers

1
Hamid Hosseinpour On

from : link this is too simple

Miles:
=ACOS(COS(RADIANS(90-Lat1)) * COS(RADIANS(90-Lat2)) + SIN(RADIANS(90-Lat1)) * 
SIN(RADIANS(90-Lat2)) * COS(RADIANS(Long1-Long2))) * 3959

Kilometers:
=ACOS(COS(RADIANS(90-Lat1)) * COS(RADIANS(90-Lat2)) + SIN(RADIANS(90-Lat1)) * 
SIN(RADIANS(90-Lat2)) * COS(RADIANS(Long1-Long2))) * 6371