TIME function in Excel Guide with Examples

The TIME function returns a decimal number that represents a specific time. It takes three arguments: hours, minutes, and seconds, to return the corresponding decimal value.

The TIME function allows users to manipulate and format time values in a variety of ways. With this function, users can easily:

• calculate the time elapsed between two points in time,
• convert between different time formats,
• perform other time-related calculations.

The function can be used in conjunction with other Excel functions to perform more complex calculations involving time, such as:

• calculating the average time spent on a task
• or the total time spent on a project.

Its flexibility and ease of use make it an essential tool for anyone working with time data in Excel.

=TIME(hour, minute, second)

Where:

• hour: an integer representing the hour of the time (0-23)
• minute: an integer representing the minute of the time (0-59)
• second: an integer representing the second of the time (0-59)

All arguments are required, and the function returns a serial number representing the time in Excel’s internal date and time format.

The example shows us that the TIME formula summarizes hours, minutes, and seconds in one cell which can be useful if you have scattered data retrieved from the system.

Once you’ve entered the formula and compiled data in one cell you change the TIME format so that it fits your needs and is easy to perceive. Go to toolbar -> Number and a pop-up window will show. And choose the best date format.

Similar to the =TODAY() function you can use =NOW() function to always have the present time in your spreadsheet. Type in the syntax and the formula will return the present time set on your computer. You can change the format (same as in the example above) so that the function displays only the time and removes the date. 

1. Open Microsoft Excel and create a new workbook.
2. Decide on the time you want to enter into the cell. For example, let’s say you want to enter the time 2:30 PM.
3. Select the cell where you want to enter the time value.
4. In the formula bar, type the following formula: =TIME(2,30,0)
5. Press Enter.
6. The cell will now display the value 2:30 PM.
7. Change the Time format.