TIME ^v2.6.131 ​

Returns the time value from hour, minute and second components.

TIME(hour, minute, second)

TIME(hour, minute, second)

Parameters ​

• hour - The hour component of the time value.
• minute - The minute component of the time value.
• second - The second component of the time value.

Examples ​

TIME(13, 30, 45)

TIME(13, 30, 45)

Result: 0.563020833

Note: Returns the time value for 1:30:45 PM.

TIME(23, 59, 59)

TIME(23, 59, 59)

Result: 0.999988426

Note: Returns the time value for 11:59:59 PM.