=DriveTimeWS returns the driving time (in hours:minutes format) from the origin to the destination calculated using the PC*MILER database. The origin and destination may be entered as a city with a state abbreviation (e.g. Paris, TX), a city/state and address, a ZIP/Postal code, SPLC, latitude/longitude point, or a custom place created in ContentTools. (Applicable licensing applies for certain types of data.)


Syntax

=DriveTimeWS (origin, destination, routetype, dims, units, LCV, dataversion, traffic, hazmats, highwayonly)


If you want to use some of the non-required arguments, but not all of them, include commas as placeholders for the arguments you are leaving out. 


For example, if you want a practical route between 13090 and 17815 in PC*MILER 38, the syntax would be:


=DriveTimeWS(13090,17815,Prac,,,,PCM38)



Arguments

ArgumentDescription
Required?
Values
origin
The origin of the trip.
yes
A geocodable location in the PC*MILER database. Learn more about how to input locations.

Examples:
Princeton, NJ

08540

M4C 4Y7
40.420833N,74.561111W
new york, ny;118 broadway
191690000
destination
The destination of the trip.
yes
A geocodable location in the PC*MILER database. Learn more about how to input locations.
routetype
The PC*MILER route type to be used in mileage calculations.  Learn more about PC*MILER route types.
no
Prac for Practical routing
Short for Shortest routing
Natl for State + National Network routing
Toll for Toll Discouraged routing*
Air for the Air Distance

or, a combination:

Prac|Natl
Short|Toll

Practical is the Default.
*Requires license for toll data.
dims
The truck's dimensions.
no
Enter a number for each dimension in this order: height in inches; width in inches, length in feet, weight in pounds and number of axles.

Each dimension must be separated by a comma. Leave a blank between two commas if you want to enter some values but not all.

Examples:
162,96,53,80000,8
162,,53,,8
units
The units of measurement used in the dims argument.
no
English (Default)
Metric
LCV
Indicates whether the truck is a multi-trailer or longer combination vehicle.
no
True
False (Default)
dataversion
The data version to be used in mileage calculations. (For users licensed for multiple data versions.)
no
Enter PCM plus the version number:
The range is PCM18 to PCMXX (Current Version) 
Current version is default
traffic
Indicates whether or not use traffic data.
(For users licensed for traffic data.)
no
True
False (Default)
hazmats A list of the hazmat categories that should be applied to the routes created for mileage calculations.
no

0 = None (Default)

1 = General

2 = Caustic

3 = Explosives

4 = Flammable

5 = Inhalants

6 = Radioactive

7 = HarmfulToWater

8 = Tunnel

(Separate by commas to pass more than one category in this argument.)
highwayonlyCalculates routes using an air distance from the midpoint of the truck-usable highway segment that is nearest to the destination postal code or city/state.
noTrue
False (Default)