HOUR function Posted on July 2, 2018 by Tomasz Decker description: Returns an hour as a number (0-23). syntax: =HOUR( serial_number ) required arguments: serial_number A date or time in a serial number format. Tomasz DeckerSpreadsheet and Python enthusiast. Post Views: 21