TIME (create time)

<< Click to Display Table of Contents >>

TIME (create time)

Syntax:

TIME(Hour, Minute, Second)

Description:

Returns a serial date value based on the specified Hour, Minute and Second.

Example:

TIME(0, 20, 0) returns 0.01389, the serial date value for the corresponding time. PlanMaker automatically applies the number format "Date/Time" to it (e.g., 00:20:00 is displayed).

See also:

TIMEVALUE, DATE, DATEVALUE