1
Download Manual PlanMaker
Transcript
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 TIMEDIFF (time difference) Syntax: TIMEDIFF(StartTime, EndTime) Description: Returns the time elapsed between two time values. StartTime is the start time. EndTime is the end time. Both can be either time values or date values including a time. Please note that in the latter case, both StartTime and EndTime have to include a date, otherwise a #VALUE! error value is returned. Manual PlanMaker Formulas and functions 669
