View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
helene and gabor helene and gabor is offline
external usenet poster
 
Posts: 58
Default Calculating Distance in MIles

Hello Dennis,

The latitudes can be North or South, the longitudes East or West.

Best Regards

Gabor Sebo

Have program.

-----------------------------------------------------------------------------------------------------------------------------------------------------
"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