TIME Function In Excel

The TIME function returns the time as a decimal number. We can format it to the HH:MM:SS format of time with AM or PM details. If the cell format is set as General before the function is entered, the result will be in decimal, but if the cell format is set as TIME before the function is entered, the result will be in time format.

The syntax of the TIME Function in Excel is =TIME(hour, minute, second)
For example, let us use the TIME function to return the time in the correct format.
First, the required time format is set in the cells.

Select cell A1, enter the formula =TIME(10,10,10), and press the “Enter” key. The output is “10:10 AM”.



Select cell A2, enter the formula =TIME(23,20,20), and press the “Enter” key. The output is “11:20 PM”.



The output is shown above.

We can insert the TIME function in Excel as follows:
1.     Select an empty cell for the output.
2.     Type =TIME( in the selected cell. [Alternatively, type =T or =TI and double-click the TIME function from the Excel suggestions.]
3.     Enter the arguments as values or cell references.
4.     Press the “Enter” key.

The TIME Function in Excel is in the Formulas tab. We can insert the formula as follows:

First, choose an empty cell for the output → select the “Formulas” tab → go to the “Functions Library” group → click the “Date & Time” drop-down → select the “TIME” function, as shown below.