|
<< Click to Display Table of Contents >> TIME (create time) |
Syntax:
TIME(Hour, Minute, Second)
Description:
This 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.
However, PlanMaker automatically formats this date value in the number format "Date/Time", thus the cell displays: 00:20:00.
See also: