Learn How to Use Microsoft Excel HOUR Function
In this article, you will learn how to use the MS Excel HOUR function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel HOUR function return value and syntax with the help of some examples.
Microsoft Excel Hour Function
The main purpose of the HOUR function is to get an hour as a number (0-23) from the time. That means you can use the MS Excel HOUR function to return the hour component of the time as a number between 0 - 23. For example, with the given time 8:30 AM, the HOUR function will return 8, so the HOUR function can be used to extract hour into the particular cell, similar to the TIME function.
HOUR Function Return Value
HOUR function will return the number between 0 to 23.
HOUR Function Syntax
- serial-number: It is the valid Excel time.
How to Use Microsoft Excel HOUR Function?
The HOUR function will return the hour from the specified time, you can understand by the examples given below:
Example 1: = HOUR("10:00 AM") - The return value will be 10.
Example 2: = HOUR("10:00 PM") - The return value will be 22.
You can also use the HOUR function to extract a time into a specified cell or feed a result into another formula. Let's say; for example, the time is "9:00 AM" is A1, you can change the time with 30 minutes like:
Example 3: = TIME(HOUR(A1),30,0) - This will return 9:30 AM.
Check out the list of all other articles:
- Learn How to Lookup With Variable Sheet Name in Microsoft Excel
- Learn How to Lookup Value Between Two Numbers in Microsoft Excel
- Learn How to Lookup Up Cost for Product or Service in Microsoft Excel
- Learn How to Lookup Lowest Value in Microsoft Excel
- Learn How to Lookup Lowest Sunday Tide in Microsoft Excel
- Learn How to Lookup Latest Price in Microsoft Excel
- Learn How to Lookup Last File Version in Microsoft Excel
- Learn How to Lookup Entire Row in Microsoft Excel