Skip to content
Google Sheets

TIME function in Google Sheets

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

=TIME(hour, minute, second)

TIME syntax and parameters

Three arguments, three required.

  • hournumberRequired

    The hour component of the time.

  • minutenumberRequired

    The minute component of the time.

  • secondnumberRequired

    The second component of the time.

TIME examples

Formulas you'll actually reuse.

  1. A clock-out time from hours, minutes and seconds:

    =TIME(17, 15, 0)

    Result17:15

  2. Minutes overflow into hours — 90 minutes reads as 01:30:

    =TIME(0, 90, 0)

    Result01:30

TIME in Excel

Same name — your formula ports as-is.

Try TIME in the playground

Edit the example — nothing to install.

Preloaded with the TIME formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.