<< Click to Display Table of Contents >> HOUR (hour) |
Syntax:
HOUR(Time)
Description:
Returns the hour of a time value.
Example:
HOUR("12:34:56 AM") returns 12
HOUR("09/25/2018 10:30:56") returns 10
If cell A1 contains a date with the time 10:30:56 then HOUR(A1) returns 10
See also: