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: