How to Use the TIME Function in Excel

This guide explains how to use TIME Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the decimal number for a time value. The decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).

Syntax: TIME (hour, minute, second)

Inside:

- hour: The hour value of the time value wants to change the decimal, from 0 to 32767. Any value greater than 23 will be divided by 24 and the rest is considered hours.

- minute: The minute value in the value of the time you want to change the decimal number from 0 to 32767. Any value greater than 59 will be converted to hours and minutes seconds.

- second: The value of seconds in the time value you want to convert to a decimal, from 0 to 32767. Any value greater than 59 will be converted to hours and minutes seconds.

Attention:

- Time value is expressed as a decimal through the day value: 0.5 = 12 hours, 1 = 1 day.

For example:

Convert the following time values to decimal numbers using TIME ()

- In the cell to calculate enter the formula: = TIME (E8, F8, G8).

- Press Enter -> result of 12:32:15 value is:

- Similarly copying the formula for the remaining values results:

Above are instructions and some specific examples when using the TIME () function in Excel.

Good luck!