HOUR

Syntax:

HOUR ( time-value )

Description: Computes the hour for the date and/or time having the given time-value.

Arguments:

Name

Type

Description

time-value

number

The date and/or time whose hour is to be computed. That date and/or time shall be expressed either as a serial value, in which case, its integer part is ignored, or as a string-constant having any valid date and/or time format, in which case, any date information shall be ignored.

Return Type and Value: number – The hour for the date and/or time having the given time-value. The returned value shall be in the range 0–59.

However, if time-value is out of range for the current date base value, #NUM! is returned.

example: