Article updated on January 30, 2018

Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Formula in cell C3:

=HOUR(B3)

Excel Function Syntax

HOUR(serial_number)

Arguments

serial_number Required. An Excel time value that you want to calculate the hour of.

Comments

Excel time (serial_number) is actually a number ranging between 0 (12:00 A.M.) and 1 in Excel and then formatted as time.

Example, 12:00 PM is represented as 0.5 because it is half of a day, you can verify this by typing 12:00 PM in a cell and then change the cell formatting to general.

This will show the value as Excel interprets it.