HOUR
Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 AM) to 23 (11:00 PM)
Syntax
HOUR(serial_number)
Parameters
- serial_number: Required. The time that contains the hour you want to find
Example
=HOUR("3:30 PM")