Time Function returns the decimal number for a particular time, representing the portion of the day value that is 24 hours.
The decimal number ranges from 0 (12:00:00 am) to 0.999988426 (23:59:59 pm).
Formula:
= TIME(hour, minute, second)
Explanations:
- Hour is required. A number representing the hour. When a number is greater than 23, it will be divided by 24 and the remainder will be treated as the hour value. For example, = TIME(50, 00, 00) = TIME(2,00,00)
- Minute is required. A number representing the minute. When a number is greater than 59, it will be converted to hours and minutes. The number is divided by 60, the integer will be the hours and the remainder will be the minutes. For example: TIME(0:81:00)=TIME(1:21:00)
- Second is required. A number representing the second. When a number is greater than 59, it will be converted to hours, minutes, and seconds. For example, TIME(0,0,1500) = TIME(0,25,21)
