TIME Function in Google Sheets

Create a time value from individual hour, minute, and second components using the TIME function.

TIME Function

The TIME function in Google Sheets creates a time value from individual hour, minute, and second components.

Syntax

TIME(hour, minute, second)
  • hour: The hour component of the time.
  • minute: The minute component of the time.
  • second: The second component of the time.

Examples

  1. Create a Specific Time

Create a time value for 13:45:30:

=TIME(13, 45, 30)
  1. Create Time Using Cell References

Create a time from values in cells A1, B1, and C1:

=TIME(A1, B1, C1)

Notes

  • Returns a time serial number that can be formatted as a time.
  • Useful for combining separate time values into a single time.
  • HOUR: Extracts the hour from a time.
  • MINUTE: Extracts the minute from a time.