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.