HOUR
Date

Converts a serial number to an hour

Syntax:

=HOUR(serial_number)

Example:

=HOUR("12:00:00 PM")