Added by Kurtis Cruzada, last edited by Kurtis Cruzada on Oct 02, 2007

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

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"
 
report: HOUR([BTime]) 		13