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.

example: