Microsoft Access Function Library: Hour()

[bbasujon]

Function: Hour()

Purpose: The Hour() function converts a numeric or string expression containing a time value into an integer between 0 and 23 representing the hour of the day within that time value.

Usage: Hour(time)

Time is a numeric or string value representing a time.

Returns: Whole number between 0 and 23 representing the hour of the day.

Example


Hour("2:14:42 PM") = 14