Excel Tutorial – HOUR

The HOUR function in Microsoft Excel is a function that extracts the hour from a time or date/time value. This can be useful if you want to perform calculations based on the hour or if you want to extract specific hours from a list of times.

To use the HOUR function, follow these steps:

1. Open your Excel workbook and navigate to the cell where you want to apply the HOUR function.
2. Type “=HOUR(” into the cell, followed by the cell reference or time that you want to extract the hour from. For example, if you want to extract the hour from the time in cell A1, you would type “=HOUR(A1)”.
3. Press the “Enter” key to complete the formula. The cell will now display the hour of the time.

Here’s an example of how you can use the HOUR function in a formula:

=IF(HOUR(A1)=12, “Noon”, “Not noon”)

In this example, the HOUR function is used to extract the hour from the time in cell A1. The IF function then checks if the hour is 12 and displays “Noon” if it is, or “Not noon” if it is not.

You can also use the HOUR function in conjunction with other time functions, such as the MINUTE and SECOND functions, to extract the minute and second from a time. For example:

=HOUR(A1)&”:”&MINUTE(A1)&”:”&SECOND(A1)

This formula would extract the hour, minute, and second from the time in cell A1 and combine them into a new time in the format “hh:mm:ss”.