For example, with a time of 9:00 AM, HOUR will return 9.
HOUR takes just oneargument,serial_number, which must be a validExcel dateor a validExcel time.
Times can be supplied to the HOUR function as text (e.g.
“7:45 PM”) or as decimal numbers (e.g.
0.5, which equals 12:00 PM).
The HOUR function will “reset” to 0 every 24 hours (like a clock).
To work with hour values larger than 24, use a formula toconvert time to decimal hours.
For example:
Example #2 - Minutes ignored
The HOUR function ignores minutes and seconds.
When given a date that includes time, the HOUR function will extract the hour and ignore the date.
If the date contains no time value, HOUR returns 0 (zero) which is midnight.
The TIME function is useful when you want to assemble a proper time inside another formula.
