HOUR(time_code)

The HOUR function converts a time_code to an hour. The hour is calculated using the 24-hour clock as a basis, running from 0 at 12 PM (or 0:00 hours) to 23 at 11 PM (or 23:00 hours). 24-hour cycles correspond to a time code increment of 1. The argument for HOUR can be in either text or time code format.

Examples:

Formula

Returns

HOUR(0.3)

7

HOUR(1.5)

12

HOUR(455.5)

21

HOUR("9:30 PM")

21

HOUR("21:30:45")

21.

See also:

Other date functions