You can use the Google Maps Directions API to calculate travel time and distance using a number of travel modes. You can used VBAJSON to create an Excel function that provides this data in Microsoft Excel! In this video, we create both travel time and travel distance functions in Excel VBA.
Links:
Written tutorial: https://syntaxbytetutorials.com/excel...
VBAJSON: https://github.com/VBAtools/VBAJSON
Directions API Start (Get an API Key): http://bit.ly/googlemapsgettingstarted
Recommended book: https://worldly.link/go/rqlppu