HOUR

Returns the hour component [0…23] of the specified time.

Syntax

HOUR( Time time ) → Integer

Parameters

time

Required. The time that contains the hour.

Remarks

Time values are a part of date values and are represented by decimal numbers. For example, 12:00 PM is represented by 0.5 because it is exactly halfway through a day.

Example

Formula

=HOUR(NOW())

See Also

Function Reference
DAY Function
MINUTE Function
MONTH Function
NOW Function
WEEKDAY Function
YEAR Function