TIME function
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.
Syntax
TIME(hour, minute, second)
- hour is an integer that represents the hour.
- minute is an integer that represents the minute.
- second is an integer that represents the second.
Example
=TIME("0,0,0") returns 00:00:00.
=TIME("4,20,4") returns 04:20:04.