TIME

Converts a provided hour, minute, and second into a time.

Parameter List

Syntax
TIME(hourminutesecond)
hour

The hour component of the time as a number from 0-23. For example: 16 , 3 or 23.

minute

The minute component of the time as a number from 0-59. For example: 46 , 3 or 23.

second

The second component of the time as a number from 0-59. For example: 46 , 3 or 23.

Examples

TIME(11, 30, 25) returns 11:30:25