If the coordinates for Point 1 are in B2 and C2 and the coordinates for Point 2 are in B3 and C3 then it could be entered as distVincentySignItB2 SignItC2 SignItB3 SignItC3 The result for the 2 sample points used above should be 54972271 and this result is in Meters. Calculate distance between coordinates using Google Maps in Excel To get Google Maps distance between two coordinates simply use the same GetDistance function as above and replace the start and dest parameters with the coordinates in this format. This method uses spherical triangles and measures the sides and angles of each to calculate the distance between points.
The calculator uses Haversine formula to calculate the distance between the two locations entered.
Latitudes and longitudes may be entered in any of three different formats decimal degrees DDDD degrees and decimal minutes DDMMMM or degrees minutes and decimal seconds DDMMSSSS. Nautical miles n mi statute miles sm or kilometers km and click Compute. That three thousand number in the end is the radius of Earth in Nautical Miles. Distance Between Two Points The distance formula is derived from the Pythagorean theorem.