HOUR
Converts a serial number to an hour.
Date & TimeDates & Time Calculations
What it does
Returns the hour component (0-23) of a time.
Syntax
HOUR(serial_number)
Arguments
serial_number(time) — Time value.
Examples
Get Hour
Extract hour from 15:30.
FORMULA
=HOUR("15:30")RESULT
15
SAMPLE DATA
| A | |
|---|---|
| 1 | Time |
| 2 | 3:30 PM |