# How to Use Excel 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:

https://www.microsoft.com/en-in/microsoft-365/excel

## 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.

## Syntax

• 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 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.

## Examples:

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.
• And, we have to apply the above-mentioned formula in a specific cell where you want to get the output and hit the  button.
• 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.

=TIME(18,30,0)

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