TIME /text/scalc/01/func_time.xhp TIME function

TIME

TIME returns the current time value from values for hours, minutes and seconds. This function can be used to convert a time based on these three elements to a decimal time value. TIME(Hour; Minute; Second) Use an integer to set the Hour. Use an integer to set the Minute. Use an integer to set the Second. =TIME(0;0;0) returns 00:00:00 =TIME(4;20;4) returns 04:20:04