Skip to content

How to Use Excel TIME Function?

Listen to this article.
TIME FunctionPin
TIME Function

TIME Function in Excel: We all know that time is the only unstoppable thing in the universe. It always moves forward not backward. It is the measured or measurable period during which an action, process, or condition exists or continues. Excel uses Time Function to create time on your worksheet. You can specify the hour, minutes, and seconds value inside the TIME function as well, and the time function will return the proper time format.

In this article, you will understand how to use the Excel TIME Function in the worksheet. Get the official version of MS Excel from the following link:

Excel TIME FunctionPin
Excel TIME Function

Description of TIME Function

  • It is one of the built-in functions in Microsoft Excel.
  • The TIME function helps to insert time in the spreadsheet with individual hour, minute, and second components.


  • Here, you will see the syntax of the TIME function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.

=TIME(Hours, Minutes, Seconds)

Time Format: The default time format is 24 Hours timing. The TIME function will calculate the correct time from your input. The time function returns the time in the “hour:minutes (AM or PM)” format only. If you wish you can change the time format.

Arguments Explanation

  • Hours – The input number that represents hours.
  • Minutes – Minute for the time, you want to create.
  • Seconds – The input number that represents seconds.


Take a glance at the following examples to understand how the TIME function works in Excel.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • In the following example, you can see the input values in cells B3, C3, & D3. We are going to apply the TIME function to get time with these values.
Input valuesPin
Input values
  • And, we have to apply the above-mentioned formula in a specific cell where you want to get the output and hit the Enter button.
Enter the formulaPin
Enter the formula
  • After executing the formula, you will get the result, as shown in the below image.
  • We can also apply the TIME function in the following format. It helps to print the time in the formula cell itself.
  • For that, we have entered the following formula in the spreadsheet, as shown in the image.


Apply the formulaPin
Apply the formula
  • After clicking on the Enter button, you will get the output as shown in the below screenshot.

A Short Summary

In the above article, we have demonstrated how to use the TIME function in Excel with its syntax, explanation, and examples. I hope that it is helpful to you. Kindly leave your suggestions or feedback in the below comment box. To learn more about Excel functions, then visit our webpage

Video Tutorial

Here, we will see how to apply the TIME function in Excel.

Related Articles:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...