Returns the hour (0 through 23) from a time.
Syntax
HOUR( time )
time
format: h:m a
h (required) - An integer between 0 and 23 representing hour of the day.
m (required) - An integer between 0 and 59 reprsenting minute of an hour.
a (optional) - A string either "am" or "pm" if using an integer between 1 and 12 for hour of the day.
Examples
Syntax |
Result |
|---|---|
report: HOUR("1:01 pm") |
13 |
report: HOUR("13:01") |
13 |
BTime = "13:01" |
13 |