Calculating Distance with Latitude and Longitude

Excel file teaching how to perform Calculating Distance with Latitude and Longitude operation.

Excel Powered Calculating Distance with Latitude and Longitude

Coordinates are entered into the table in degrees. Distance is converted to kilometers using the Haversine formula. The result cell is automatically updated. A warning system is in place for incorrect entries. A graphical map view is optional.

Hope it is useful.