On Tue, 8 Mar 2005 16:33:03 -0800, Jon re Excel <Jon re
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