Question: how to calculate distance between two latitude and longitude in excel?
Answer: Total Degrees (in the decimal form) = Deg + [Mins / 60] + [Seconds / 3600] Nautical Miles= ACOS [(sin(Lat_place_1*PI()/180)*sin(Lat_place_2*PI()/180)+ Step 1: Find the Developer tab in your version of Excel. Step 2: Look for the “Visual Basic” tab. ...  Step 3: Insert —> Module.