ExcelBanter - CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS (https://www.excelbanter.com/excel-worksheet-functions/16764-calculate-distance-between-two-gps-positions.html)

Jon re Excel

CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS

is there a formula for this?

Dave Peterson

A visit to Chip Pearson's site is in order:
http://www.cpearson.com/excel/latlong.htm

Jon re Excel wrote:

is there a formula for this?

--

Dave Peterson

Ron Rosenfeld

On Tue, 8 Mar 2005 16:33:03 -0800, Jon re Excel <Jon re
wrote:

is there a formula for this?

=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

All times are GMT +1. The time now is 04:35 AM.