Calculating Distance between two points using Geography as Data Type in Excel

pcull2424 

in B2 is the latitude of location 1 and in B3 the longitude

in B5 is the latitude of location 2 and in B6 the longitude

each degree - decimal

in C2 stands: = B2 * PI () / 180

copy to C6

The distance in km is:

= TEXT (ARCCOS (SIN (C2) * SIN (C5) + COS (C2) * COS (C5) * COS (C6-C3)) * 6378,137, "#. ## 0,0") & "km "

If you don't know how to convert to decimal:

in F1 the hours / in G1 the minutes / in H1 the seconds

= F1 + G1 / 60 + H1 / 3600

Enclosed a calculation file

Great circle navigation = distance calculations on the earth's surface:

Got this from the Internet, don't know where, but in my notes there is this file from a Mr. Klaus Kühnlein who is/or was the Pope in this area in German-speaking countries.

It's really a great job...WoW!

Hope I could help you with this information.

If this information helped you, please mark this post as "Correct answer" and click on like (hand with thumbs up), so that other members can benefit from this information later. 

Nikolino

I know I don't know anything (Socrates)