The HOUR returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

HOUR takes 1 required argument and no optional arguments:

Syntax: HOUR(serial_number)

#1)
Using the HOUR function:
#2)
The arguments for the HOUR function are:
Argument Required? Description
serial_number Required The time that contains the hour you want to find. Times may be entered as text strings within quotation marks (for example, "7:30 AM"), as decimal numbers (for example, 0.3125, which represents 7:30 AM), or as results of other formulas or functions (for example, TIMEVALUE("7:30 AM")).

Summary

The HOUR returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).
comments powered by Disqus