As you work in Excel, you may find yourself using time units. These include hours, minutes, seconds, and more. It’s often useful to display an hour value in a cell of its own. Fortunately, this is very easy to do in Excel. Let’s learn how to use HOUR in Microsoft Excel.
How to Use HOUR in Excel
Consider a list of times: 12:30, 9:33, 18:55, and so on. These are simple hour-and-minute times that you may encounter when you work with your data. It’s helpful to have the hour values listed separately, especially if you are performing calculations like finding the average hour, for example.
Of course, you could list the hours in their own cells by typing them in manually. But this is repetitive, and would take far too long if you had a lengthy list of times. This is where Excel’s HOUR function comes in.
To use HOUR, click into any empty cell in your workbook. It’s worth noting here that HOUR is based on 24-hour times. In other words, typing 6:35 will be treated as 6:35 AM. To type 6:35 PM, you should use 18:35.
In the cell you’ve selected, type an = sign, followed by HOUR(. Your formula reads:
=HOUR(
Then, click into the cell containing a time that you want to extract the hour from. Here, we’ll use cell A1. Lastly, close the parentheses, completing your formula as follows:
=HOUR(A1)
Hit Enter on your keyboard, and Excel displays the hour value: 12. From here, you can click and drag downward to copy your formula over the other times listed.
As you can see, Excel’s HOUR function makes it easy to extract the hour from a given time input. It’s easy to use, and fast to copy across large volumes of data. This streamlines your analysis tasks and makes your data more useful to you.
YEAR in Excel