TRAVELTIME_API helps spreadsheet users plan trips by finding the time needed to travel between two points. You can calculate the time for hundreds of address pairs in seconds. This formula is the paid version of TRAVELTIME. It has unlimited daily usage, ignoring Google’s quotas and has the “avoid” feature. You can pay through the add-on or using this payment link.
❗This custom formula is only available to users of the Travel Formulas add-on in the Google Workspace Marketplace. Travel Formulas uses Google Maps for you while you stay in Sheets.
❗This function outputs text. Use the VALUE function to convert it to a number.
Purpose
The TRAVELTIME_API function Returns the trip duration between two locations in HH:MM without impacting your daily usage limits.
Syntax
Returns the trip duration between two locations in HH:MM
=TRAVELTIME_API(origin, destination, mode, avoid, departure_time)
origin – The starting address
destination – The ending address
mode – The mode of travel (“driving”, “walking”, “bicycling”, “transit”) [optional, defaults to driving]
avoid – Features to avoid: 0-None, 1–Tolls, 2–Highways, 3–Ferries, 4–Indoors [optional, defaults to 0]
departure_time – A datetime in the FUTURE for transit/driving in traffic. Best to use a cell reference formatted to datetime [optional]
All Paid Travel Functions
TRAVELDISTANCE_API – Find the distance between two locations
TRAVELTIME_API – Find the travel time between two locations
TRAVELTOLLS_API – Returns the estimated tolls for travelling between two locations