The HOUR function returns the hour component of a given time as a whole number between 0 and 23.



serial_number The time for which you want to extract the hour component.

About HOUR

When dealing with time-based data in Excel, you can rely on the HOUR function to extract the hour part of a given time. This function is handy when you need to specifically isolate and manipulate the hour value within a time entry, aiding in various time-related calculations and analyses within your spreadsheets. By utilizing HOUR, you can better manage and interpret time data based on the hour component, facilitating accurate time-based computations and representations in your Excel projects.


If cell A1 contains the time 11:45:30 AM, you can use the formula =HOUR(A1) to extract the hour value 11.

Given a different cell B1 with a time entry of 20:30:15, applying =HOUR(B1) will yield the hour value 20 from the provided time.

For a time value like 03:00:00 PM in cell C1, the formula =HOUR(C1) will extract the hour component 15 representing 3:00 PM.


What format does the HOUR function use for the extracted hour value?

The HOUR function follows the 24-hour clock format, where the hour value is returned as a whole number between 0 and 23, representing each hour of the day from midnight (0) to 11 PM (23).

Can the HOUR function handle time values with minutes and seconds?

Yes, the HOUR function can extract the hour component from time values that include minutes and seconds. It specifically focuses on isolating and returning the hour part of the provided time entry.

Are there any limitations to the range of values the HOUR function can output?

The HOUR function returns the hour component as a number between 0 and 23, inclusive. This range corresponds to the valid hours within a day according to the 24-hour time format.

Related functions