The HOUR function returns the hour of a time value as an integer.
Formula:
=HOUR(serial_number)
Explanations:
Start_date is required, The time with the hour you want to find.
Cautions:
Time value is the portion of the day value which is 24 hours.
How to Use HOUR Function
