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: