The HOUR function returns the hour for a given date/time value or time string.
HOUR(time)
time: A date/time value or time string.
Notes
The hour returned is in 24-hour format (0 is midnight, 23 is 11:00 p.m.).
Examples |
|---|
=HOUR(NOW()) returns the current hour of the day. =HOUR(“4/6/88 11:59:22pm”) returns 23. |