HOUR

Definition: HOUR is a function that returns the hour component of a time value.

Syntax: =HOUR(serial_number)

Situation: This formula is suitable when you need to find the hour component of a time value.

Example: If you have a time value of 3:30 PM, the hour component can be found using the formula =HOUR(“3:30 PM”), which returns 15.