Enter the latitude and longitude of two locations and select calculate. P1 -3 4 sinSigma 2 _ -3 4 cos2SigmaM 2 P2 upper_B sinSigma P3 cos2SigmaM upper_B 4 _ cosSigma -1 2 _ cos2SigmaM 2 - _ upper_B 6 cos2SigmaM P1 complete deltaSigma calculation deltaSigma P2 P3 calculate the distance s low_b upper_A _ sigma - deltaSigma round distance to millimeters distVincenty Rounds 3 End Function Function SignItDegree_Dec As String _ As Double Input. The shortest distance between two points on the surface of a sphere is an arc not a line.
With your coordinates in radians you can use a trigonometric formula to calculate distance along the surface of a sphere.
Convert Latitude and Longitude to Decimal Degrees in Excel. You can structure your point coordinates into 4 columns Lat1 Lon1 Lat2 Lon2 in decimal degrees and the distance will be calculated in meters. With your coordinates in radians you can use a trigonometric formula to calculate distance along the surface of a sphere. Using Excel to calculate distance travel time between two points Bing Maps API.