Excel HOUR Function

HomeExcel FunctionsExcel HOUR Function (Example + Sample File)

What is EXCEL HOUR FUNCTION

The Excel HOUR Function is listed under Microsoft Excel's Time Functions category. It 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.

How to use it

To learn how to use the HOUR function in Excel, you need to understand its syntax and arguments:

Syntax

HOUR(serial_number)

Arguments

  • serial_number: A valid time from which you want to get the hour value.

Notes

  • If you refer to a blank cell it will return 0 in the result.
  • HOUR always returns an hour in 24-hour format.

Example

To master HOUR function we need to try it out in an example, so make sure to check out the below one:

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 which 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.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.