CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS

  • Thread starter Thread starter Guest
  • Start date Start date
On Tue, 8 Mar 2005 16:33:03 -0800, Jon re Excel <Jon re
is there a formula for this?
Click to expand...


=60*180/PI()*ACOS((SIN(RADIANS(Pos1 Lat)) * SIN(RADIANS(Pos2 Lat)))
+ (COS(RADIANS(Pos1 Lat)) * COS(RADIANS(Pos2 Lat)) *
COS(RADIANS(Pos2 Long) - RADIANS(Pos1 Long))))

Pos1 Lat is the Latitude, in decimal degrees of position 1
and so forth.

Positions in the N latitudes and W longitudes are entered as postive numbers.
Positions in the S latitudes and E longitudes are entered as negative numbers.

The result will be in nautical miles.




--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distance between GPS points (Decimal degrees) 2
How do I calculate Track and Distance from two sets of coordinate 2
GPS Devices for dogs - advice please 3
How do I calculate the distace between two GPS coordinates? 4
Time trouble 3
Excel Lat & Long calculations in Excel 23
GPS Artwork 1
Calculate distance between two points (numbers) in a number line 5

Back
Top