How to Use the HOUR Function in Excel

This guide explains how to use HOUR Function in Excel, including its syntax, required arguments, practical examples, and common errors.

How to Use the HOUR Function in Excel screenshot

Description: The function returns the hour value of a time value, the hour is returned as an integer.

Syntax : HOUR (serial_number)

Where: serial_number is the time value want to count, is a required parameter.

Attention:

- Where serial_number value is a date value does not specify the time the function will return the value #VALUE!.

- The time value is part of the date value and it is expressed as a decimal.

For example:

Calculate the hour value in the time value in the following table:

How to Use the HOUR Function in Excel screenshot 2

- In the cell to calculate enter the formula : = HOUR (E7).

How to Use the HOUR Function in Excel screenshot 3

- Press Enter -> 25% of 24 hours is:

How to Use the HOUR Function in Excel screenshot 4

- Similarly copying the formula for the remaining values results:

How to Use the HOUR Function in Excel screenshot 5

- Where the value seri_number does not contain the hour unit -> the function returns the #VALUE! Error value

How to Use the HOUR Function in Excel screenshot 6

Above are instructions and some specific examples in working with HOUR function in Excel.

Good luck!

FAQ

The HOUR function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.

Start with an equals sign, enter HOUR, add the required arguments inside parentheses, and confirm that cell references and separators are correct.

Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.