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.