HOUR
Formula Explanation
Returns the hour portion of a time value. The hour is an integer between 0 (12:00 AM) and 23 (11:00 PM).
Formula Syntax
Enter in the result column: HOUR(time / column number)
The HOUR function syntax has the following argument:
Time or column number (required): The time value containing the hour you want to retrieve. Time values can be entered in various ways:
Text strings in quotes (e.g., "6:45 PM")
Decimal numbers (e.g., 0.78125 for 6:45 PM)
Results of other formulas or functions (e.g., TIMEVALUE("6:45 PM"))
Entering Hour(0-1) as a decimal represents the percentage of 24 hours.
Calculate 75% of 24 hours: HOUR(0.75)
Usage Example
Calculate the hour portion of the values in column CZ2 and write the results into column CZ3.
CZ3 = HOUR(CZ2)