Dear all,



I am having trouble in finding the right formula in a cell to calculate the trip distance between 2 destinations in Excel, does it have to link to the Googlemap?

Thank you.

Hi and welcome
how do you want to calculate the distance ? Orthodromy, as the crow flies?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

For Great Circle distances, the following give good approximations:
=ACOS(SIN(RADIANS(Lat1))*SIN(RADIANS(Lat2))+COS(RA DIANS(Lat1))*COS(RADIANS(Lat2))*COS(RADIANS(Long1-Long2)))*RadiusEarth
and more accurately for very small differences in Lat/Lon, particularly near the poles:
=2*ASIN(SQRT((SIN(RADIANS(Lat1-Lat2)/2))^2+COS(RADIANS(Lat1))*COS(RADIANS(Lat2))*(SIN(R ADIANS(Long1-Long2)/2))^2))*RadiusEarth
where the latitude and longitude coordinates are input as +/- decimal degrees and the earth's radius is given in miles or km, depending on which units you're using. When mixing hemispheres, enter Northern and Western coordinates as positive, and Southern and Eastern coordinates as negative.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

HUH ???

I consider myself to be fairly smart but this formula and its use certainly has me stumped. Could you provide an example using your formula ? Thank you so much sir.

For example, for flights from Sydney (SYD) to London Heathrow (LHR), then to Los Angeles (LAX) and, finally, back to Sydney (SYD), using :

with 3956.559mi & 6367.465km for the earth's (average) radius.

For a practical implementation see: https://www.msofficeforums.com/excel...using-lat.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you sir !