Introduction to HOUR Function
HOUR function returns the hour value from a valid time. Time value is made up of, hours, minutes, and seconds and the HOUR function takes hour value and ignores the rest of all.
Download Sample File
Download SAMPLE FILE to work, practice and master the TIME Functions in Excel.
Syntax of HOUR Function
HOUR(serial_number)
Arguments of HOUR Function
- serial_number: A valid time from which you want to get the hour value.
Example of HOUR Function in MS Excel
1. Use Cell Reference
In the below example, we have referred to a cell in which I have a valid time value. The function has only extracted hour in 24-Hour format from that time value. You can use this method where you have time data and you want to extract hour from those values.
2. Use Date as a Reference
In the below example, we have used a date that has a time value in it and HOUR has extracted the hour as an integer from it.
And if you convert that date into value by changing its format, you’ll get to know that it has time value as decimals.
Other Excel Time Functions Tutorials
You can explore and master other Time functions in Microsoft Excel. Here is a complete list of Time functions available in Microsoft Excel.
