I want to measure the distance between two points on the globe (from any city in the world to another, LA to Sydney(Aus) say for example). I know the longitude and latitude for each city. Is there a formula that would convert this information to a distance in miles or Km?
I’m interested in ballpark results (say ±10% from true distance) so the formula doesn’t have to be overwhelmingly complicated.
I know I can google each individual city and find out but it would take time. I want a formula that can be used in a spreadsheet to calculate a matrix of many cities without having to search for each one on some website.
Thanking you all in advance.