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!

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

 Leave a 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)