Thread: [Solved] Calculate trip distance in Excel
View Single Post
 
Old 04-09-2024, 02:59 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,465
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
For example, for flights from Sydney (SYD) to London Heathrow (LHR), then to Los Angeles (LAX) and, finally, back to Sydney (SYD), using :

Code:
                                                                                Distance         
From         Lat1           Lon1       To          Lat2          Lon2        (mi)       (km)
SYD      -33.94610      151.17700      LHR      51.47060      -0.46194      10570      17011
LHR       51.47060       -0.46194      LAX      33.94250    -118.40800       5440       8755
LAX       33.94250     -118.40800      SYD     -33.94610     151.17700       7490      12054
with 3956.559mi & 6367.465km for the earth's (average) radius.

For a practical implementation see: https://www.msofficeforums.com/excel...using-lat.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote