Excel TIME Function

Excel TIME Function


The Excel TIME function is a built-in function that allows you to create a time with individual hour, minute, and second components.


Create a time with hours, minutes, and seconds

Return value 

A decimal number representing a particular time in Excel.


=TIME (hour, minute, second)


  • hour – The hour for the time you wish to create.
  • minute – The minute for the time you wish to create.
  • second – The second for the time you wish to create.

Usage notes 

The TIME function creates a date in serial number format from the hour, minute, and second components you specify. Use it to create a valid time when you have (or can supply) these component values separately. Once you have a valid time, you can format it any way you like.

1 votes. 4.5 / 5

Excel - Excel Functions - Excel Formulas