HOUR
The HOUR function returns the hour component of a given time as a number between 0 and 23.
Syntax 🔗
=HOUR(serial_number)
serial_number | The time for which you want to extract the hour component. |
About HOUR 🔗
Use the HOUR function in Excel to extract the hour from a given time. This function helps you isolate and work with the hour value in time entries, which can be useful for time-related calculations and analyses in your spreadsheets. By using HOUR, you can manage and interpret time data based on the hour component for accurate computations and representations in your Excel projects.
Examples 🔗
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.
Notes 🔗
Use the HOUR function with a valid time value or a cell reference containing the time. The function returns the hour as an integer from 0 to 23, following the 24-hour clock format.
Questions 🔗
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.