HOUR
Returns the hour component of a time as a whole number, so =HOUR(E5) on 9:45:22 gives 9. Its cell uses the General format, not a time format.
When to use
Part of the group of functions (with MINUTE and SECOND) that take a time value apart, shown in the Time Functions sheet.
See Lec 05.