The Excel HOUR function returns the hour integer from a time serial number ranging from 0 to 24.
Where the serial_number is a date in a format Excel recognises known as the date-time serial number.
Excel HOUR Function Examples
Tip: Cell C11 returns 12 because 12 hours is 50% of 24 hours.
The HOUR function will also accept a text string, no need to convert the text to a date-time serial number first e.g. "4:15 AM"
You can also use the HOUR Function to populate the hour argument of the TIME function e.g.
Free eBook - Working with Date & Time in Excel
Everything you need to know about Date and Time in Excel, including all Date functions explained with examples - Download the free eBook and Excel file with detailed instructions.
Enter your email address below to download the sample workbook.
Download the Excel Workbook and PDF. Note: This is a zip file including an Excel workbook with detailed instructions and a PDF version for your reference.
|Excel TIME Function
|Returns a time serial number, from separate hour, minute and second values
|Excel MINUTE Function
|Returns the minute part of a time serial number
|Excel SECOND Function
|Returns the seconds part of a time serial number
|Excel DATE Function
|Returns a date in serial number from separate year, month and day values
|Excel Time Calculation Tricks
|Time and Date 101, plus common questions answered e.g. convert time to decimals, round time etc.