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 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.
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 Enter 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 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 Aawexcel.com.
Video Tutorial
Here, we will see how to apply the TIME function in Excel.
Related Articles:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.
