Skip to content
Excel

TIME function in Excel

Returns the serial number of a particular time

=TIME(hour, minute, second)

TIME syntax and parameters

Three arguments, three required.

  • hournumberRequired

    A number from 0 (zero) to 32767 representing the hour. Any value greater than 23 will be divided by 24 and the remainder will be treated as the hour value. For example, TIME(27,0,0) = TIME(3,0,0) = .125 or 3:00 AM.

  • minutenumberRequired

    A number from 0 to 32767 representing the minute. Any value greater than 59 will be converted to hours and minutes. For example, TIME(0,750,0) = TIME(12,30,0) = .520833 or 12:30 PM.

  • secondnumberRequired

    A number from 0 to 32767 representing the second. Any value greater than 59 will be converted to hours, minutes, and seconds. For example, TIME(0,0,2000) = TIME(0,33,22) = .023148 or 12:33:20 AM

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 Google Sheets

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 Excel gets this done.