TIME
Syntax:
TIME ( hour , minute , second )
Description: Computes the serial value for the given time.
Arguments:
Name |
Type |
Description |
|---|---|---|
hour |
number |
A number in the range 0–32767, inclusive, truncated to integer, that represents the hour. Any value greater than 23 shall be divided by 24 and the remainder shall be treated as the hour value. |
minute |
number |
A number in the range 0–32767, inclusive, truncated to integer, that represents the minute. Any value greater than 59 shall be converted to the corresponding number of hours and minutes. |
second |
number |
A number in the range 0–32767, inclusive, truncated to integer, that represents the second. Any value greater than 59 shall be converted to the corresponding number of hours, minutes, and seconds. |
Return Type and Value: number – The serial value for the given time, as a value greater than or equal to 0 and less than or equal to 1.
However, if hour, minute, or second are out of range, #NUM! is returned.