Travel function

 

The Excel Travel function returns the distance or duration required to travel between two places. For a given pair of places, both the distance and the duration can vary according to the mode of transport (driving, walking or bicycling) and the direction (the distance from A to B may not be the same as the distance from B to A; for example, due to one-way streets)

Usage:

=travel(request, start, finish, mode)

Where:

request is the information desired, “distance” or “duration”
start is the name of the place of origin
request is the name of the destination
mode is the mode of transport: “driving”, “walking” or “bicycling”

Examples:

Excel Formula Result Remarks
=Travel(“distance”,”london”,”paris”,”driving”) 464625 metres
=Travel(“duration”,”london”,”paris”,”walking”) 2.06:45:58 2 days, 6 hours, 45 minutes and 58 seconds
 Posted by on 2011/04/04 at 13:10

  2 Responses to “Travel function”

  1. I found in excel 2016, instead of a comma, a point comma. Very good plugin! SUPER use it every year for TAX Kilometre registration!

    • This is by design, Geodesix uses your regional settings, whereas the interface to Google mandates CVS format.

Leave a Reply to maurice Cancel reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

*