ReferenceFunctionsDate & Time Functions
HOUR
Extracts the hour component (`0` to `23`) from a time or datetime serial.
Summary
Extracts the hour component (0 to 23) from a time or datetime serial.
Remarks
- For values
>= 1, only the fractional time part is used. - For values
< 1, the value is treated directly as a time fraction. - Date-system choice does not affect hour extraction because only the fractional part is used.
Examples
Extract hour from noon
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
12
Extract hour from datetime serial
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
18
Related functions
FAQ
Why is HOUR unchanged across 1900 and 1904 date systems?
HOUR reads only the fractional time component of a serial, so date-system epoch differences do not affect it.
Runtime metadata
Category
Date & Time
Signature
HOUR(arg1: Number)Arity
min 1, max 1
Arguments
arg1Number · Scalar · coercion NumberLenientText
Caps
PURE
Source