Returns the hour (0 through 23) from a time.
Syntax
| Code Block |
|---|
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 |