TIME function - Function returns decimal numbers for a specific time value in Excel

The following article introduces you to the TIME function - one of the functions in the date and time group function is very popular in Excel.

TIME function - Function returns decimal numbers for a specific time value in Excel Picture 1

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 ()

TIME function - Function returns decimal numbers for a specific time value in Excel Picture 2

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

TIME function - Function returns decimal numbers for a specific time value in Excel Picture 3

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

TIME function - Function returns decimal numbers for a specific time value in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

TIME function - Function returns decimal numbers for a specific time value in Excel Picture 5

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

Good luck!