Returns the hour component [0…23] of the specified time.
Syntax
 Copy Code
|
|---|
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
Copy Code
|
|---|
=HOUR(NOW()) |
See Also
Function Reference
DAY Function
MINUTE Function
MONTH Function
NOW Function
WEEKDAY Function
YEAR Function