Thanks. I will try it out.

Dennis

"macropod" wrote in message
...
Hi Dennis,

For distances at sea level, try:
ACOS(SIN(RADIANS(Lat1))*SIN(RADIANS(Lat2))+COS(RAD IANS(Lat1))*COS(RADIANS(Lat2))*COS(RADIANS(Long1-Long2)))*RadiusEarth
whe
Lat1, Lat2, Long1-Long2 are named cells containing the latitudes and
longitudes (you could use cell addresses instead).
RadiusEarth = 3956.56 (the average distance in statute miles, but the
distance around the equator is longer than around the poles). You could
adjust this for the average distances from the center of the earth for the
start and end locations.

--
Cheers
macropod
[Microsoft MVP - Word]


"Dennis Tucker" wrote in message
...
Lets say I have two locations on the earth surface. These locations are
stated as

Location 1

geo:lat=57.64911

geo:lon=10.40744

&

Location 2

geo:lat=58.64911

geo:lon=11.40744

What is the easiest and accurate way to calculate the distance between
these locations in miles?

What is the formula?

Dennis