HOUR function is used to return the hour as a number between 0 and 23 from a given time. HOUR Function: A Brief The HOUR function in Excel extracts the hour from a given time and returns a number between 0 and 23. For example, if the time is 10:30 AM, the HOUR function will return 10. You can use this function to return the hour value in a cell. extracts the hour number between 0 and 23 Objective

Value Returned by function



Aim to get the Hour value as Number

HOUR Function will return a numeric values from the input hour value. Objective

Value Returned by function



Aim to get the Hour value as Number

HOUR Function will return a numeric values from the input hour value. Objective

Value Returned by function Objective Objective Value Returned by function Value Returned by function Aim to get the Hour value as Number

HOUR Function will return a numeric values from the input hour value. Aim to get the Hour value as Number Aim to get the Hour value as Number Hour value as Number HOUR Function will return a numeric values from the input hour value. HOUR Function will return a numeric values from the input hour value. HOUR Function: A Syntax: =HOUR(hour_value) =HOUR(hour_value) hour_value: It should be a valid excel hour value. hour_value: It should be a valid excel hour value. hour_value: Important Notes About HOUR Function: The HOUR function in Excel extracts the hour value from a given time and returns a number between 0 and 23.

For Example, if the time is 11:00 AM, the HOUR function will return the numeric value as 11. It requires only one argument, serial_number, which must be a valid Excel date or Excel time. The HOUR function in Excel extracts the hour value from a given time and returns a number between 0 and 23.

For Example, if the time is 11:00 AM, the HOUR function will return the numeric value as 11. It requires only one argument, serial_number, which must be a valid Excel date or Excel time. extracts the hour value given time number between 0 and 23 For Example, if the time is 11:00 AM, the HOUR function will return the numeric value as 11. It requires only one argument, serial_number, which must be a valid Excel date or Excel time. For Example, if the time is 11:00 AM, the HOUR function will return the numeric value as 11. It requires only one argument, serial_number, which must be a valid Excel date or Excel time. 11:00 AM 11 argument serial_number Excel date Excel time You can enter time values as text (e.g., “9:25 PM”) or as decimal numbers (e.g., 0.5, which equals 12:00 PM). The HOUR Function returns the equivalent numeric value. You can enter time values as text (e.g., “9:25 PM”) or as decimal numbers (e.g., 0.5, which equals 12:00 PM). The HOUR Function returns the equivalent numeric value. text decimal numbers 0.5 12:00 PM In the above image, The input value is 0.34 decimal value but the HOUR Function converts into a valid Excel time and returns the numeric value equivalent to the input hour value. So the HOUR function considers the decimal value as 08:09 AM and returns the numeric value as 8 in the output cell. In the above image, The input value is 0.34 decimal value but the HOUR Function converts into a valid Excel time and returns the numeric value equivalent to the input hour value. So the HOUR function considers the decimal value as 08:09 AM and returns the numeric value as 8 in the output cell. 0.34 decimal value Excel time numeric value equivalent hour value 08:09 AM numeric value as 8 Decimal Values

Equivalent Hour Value in Excel



0.01

12:14 AM



0.02

12:29 AM



0.03

12:43 AM



0.04

12:57 AM



0.05

1:12 AM



0.06

1:26 AM



0.07

1:41 AM



0.08

1:55 AM



0.09

2:10 AM



0.10

2:24 AM



0.125

3:00 AM



0.15

3:36 AM



0.1667

4:00 AM



0.20

4:48 AM



0.25

6:00 AM



0.30

7:12 AM



0.3333

8:00 AM



0.375

9:00 AM



0.40

9:36 AM



0.50

12:00 PM (Noon)



0.55

1:12 PM



0.5833

2:00 PM



0.60

2:24 PM



0.625

3:00 PM



0.6667

4:00 PM



0.70

4:48 PM



0.75

6:00 PM



0.80

7:12 PM



0.8333

8:00 PM



0.875

9:00 PM



0.90

9:36 PM



0.9167

10:00 PM



0.95

11:24 PM



1.00

12:00 AM (Midnight) Decimal Values

Equivalent Hour Value in Excel



0.01

12:14 AM



0.02

12:29 AM



0.03

12:43 AM



0.04

12:57 AM



0.05

1:12 AM



0.06

1:26 AM



0.07

1:41 AM



0.08

1:55 AM



0.09

2:10 AM



0.10

2:24 AM



0.125

3:00 AM



0.15

3:36 AM



0.1667

4:00 AM



0.20

4:48 AM



0.25

6:00 AM



0.30

7:12 AM



0.3333

8:00 AM



0.375

9:00 AM



0.40

9:36 AM



0.50

12:00 PM (Noon)



0.55

1:12 PM



0.5833

2:00 PM



0.60

2:24 PM



0.625

3:00 PM



0.6667

4:00 PM



0.70

4:48 PM



0.75

6:00 PM



0.80

7:12 PM



0.8333

8:00 PM



0.875

9:00 PM



0.90

9:36 PM



0.9167

10:00 PM



0.95

11:24 PM



1.00

12:00 AM (Midnight) Decimal Values

Equivalent Hour Value in Excel Decimal Values Decimal Values Equivalent Hour Value in Excel Equivalent Hour Value in Excel 0.01

12:14 AM 0.01 0.01 12:14 AM 12:14 AM 0.02

12:29 AM 0.02 0.02 12:29 AM 12:29 AM 0.03

12:43 AM 0.03 0.03 12:43 AM 12:43 AM 0.04

12:57 AM 0.04 0.04 12:57 AM 12:57 AM 0.05

1:12 AM 0.05 0.05 1:12 AM 1:12 AM 0.06

1:26 AM 0.06 0.06 1:26 AM 1:26 AM 0.07

1:41 AM 0.07 0.07 1:41 AM 1:41 AM 0.08

1:55 AM 0.08 0.08 1:55 AM 1:55 AM 0.09

2:10 AM 0.09 0.09 2:10 AM 2:10 AM 0.10

2:24 AM 0.10 0.10 2:24 AM 2:24 AM 0.125

3:00 AM 0.125 0.125 3:00 AM 3:00 AM 0.15

3:36 AM 0.15 0.15 3:36 AM 3:36 AM 0.1667

4:00 AM 0.1667 0.1667 4:00 AM 4:00 AM 0.20

4:48 AM 0.20 0.20 4:48 AM 4:48 AM 0.25

6:00 AM 0.25 0.25 6:00 AM 6:00 AM 0.30

7:12 AM 0.30 0.30 7:12 AM 7:12 AM 0.3333

8:00 AM 0.3333 0.3333 8:00 AM 8:00 AM 0.375

9:00 AM 0.375 0.375 9:00 AM 9:00 AM 0.40

9:36 AM 0.40 0.40 9:36 AM 9:36 AM 0.50

12:00 PM (Noon) 0.50 0.50 12:00 PM (Noon) 12:00 PM (Noon) 0.55

1:12 PM 0.55 0.55 1:12 PM 1:12 PM 0.5833

2:00 PM 0.5833 0.5833 2:00 PM 2:00 PM 0.60

2:24 PM 0.60 0.60 2:24 PM 2:24 PM 0.625

3:00 PM 0.625 0.625 3:00 PM 3:00 PM 0.6667

4:00 PM 0.6667 0.6667 4:00 PM 4:00 PM 0.70

4:48 PM 0.70 0.70 4:48 PM 4:48 PM 0.75

6:00 PM 0.75 0.75 6:00 PM 6:00 PM 0.80

7:12 PM 0.80 0.80 7:12 PM 7:12 PM 0.8333

8:00 PM 0.8333 0.8333 8:00 PM 8:00 PM 0.875

9:00 PM 0.875 0.875 9:00 PM 9:00 PM 0.90

9:36 PM 0.90 0.90 9:36 PM 9:36 PM 0.9167

10:00 PM 0.9167 0.9167 10:00 PM 10:00 PM 0.95

11:24 PM 0.95 0.95 11:24 PM 11:24 PM 1.00

12:00 AM (Midnight) 1.00 1.00 12:00 AM (Midnight) 12:00 AM (Midnight) From the above table, you can find the decimal values and equivalent hour values. The Decimal value should be lies between 0 to 1. 0 to 1 Example 1: Basic Example: The below example will make you understand the HOUR Function easily. Input Time

Formula Used

Final Result

Comments



10:45 AM

=HOUR(B3)

10

Returns 10 because the hour part is 10



5:30 PM

=HOUR(B4)

17

Returns 17 because 5 PM is represented as 17 in a 24-hour format



00:15

=HOUR(B5)

0

Returns 0, indicating midnight



23:59

=HOUR(B6)

23

Returns 23, indicating 11:59 PM



12:00 PM

=HOUR(B7)

12

Returns 12 Input Time

Formula Used

Final Result

Comments



10:45 AM

=HOUR(B3)

10

Returns 10 because the hour part is 10



5:30 PM

=HOUR(B4)

17

Returns 17 because 5 PM is represented as 17 in a 24-hour format



00:15

=HOUR(B5)

0

Returns 0, indicating midnight



23:59

=HOUR(B6)

23

Returns 23, indicating 11:59 PM



12:00 PM

=HOUR(B7)

12

Returns 12 Input Time

Formula Used

Final Result

Comments Input Time Input Time Formula Used Formula Used Final Result Final Result Comments Comments 10:45 AM

=HOUR(B3)

10

Returns 10 because the hour part is 10 10:45 AM 10:45 AM =HOUR(B3) =HOUR(B3) 10 10 Returns 10 because the hour part is 10 Returns 10 because the hour part is 10 5:30 PM

=HOUR(B4)

17

Returns 17 because 5 PM is represented as 17 in a 24-hour format 5:30 PM 5:30 PM =HOUR(B4) =HOUR(B4) 17 17 Returns 17 because 5 PM is represented as 17 in a 24-hour format Returns 17 because 5 PM is represented as 17 in a 24-hour format 00:15

=HOUR(B5)

0

Returns 0, indicating midnight 00:15 00:15 =HOUR(B5) =HOUR(B5) 0 0 Returns 0, indicating midnight Returns 0, indicating midnight 23:59

=HOUR(B6)

23

Returns 23, indicating 11:59 PM 23:59 23:59 =HOUR(B6) =HOUR(B6) 23 23 Returns 23, indicating 11:59 PM Returns 23, indicating 11:59 PM 12:00 PM

=HOUR(B7)

12

Returns 12 12:00 PM 12:00 PM =HOUR(B7) =HOUR(B7) 12 12 Returns 12 Returns 12 Example 2: Return Hour Values from Date & Time Values: If you sheet contains both date and time values in the cells, you can use the HOUR function to extract the numeric values by ignoring the date values from the input cell. numeric values by ignoring the date values Input Date and Time

Formula Used

Final Result

Comments



03-08-2025 10:30

=HOUR(B3)

10

Returns 10 because the time is 10:30 AM.



25-12-2024 00:01

=HOUR(B4)



Returns 0, as midnight is hour 0. Input Date and Time

Formula Used

Final Result

Comments



03-08-2025 10:30

=HOUR(B3)

10

Returns 10 because the time is 10:30 AM.



25-12-2024 00:01

=HOUR(B4)



Returns 0, as midnight is hour 0. Input Date and Time

Formula Used

Final Result

Comments Input Date and Time Input Date and Time Formula Used Formula Used Final Result Final Result Comments Comments 03-08-2025 10:30

=HOUR(B3)

10

Returns 10 because the time is 10:30 AM. 03-08-2025 10:30 03-08-2025 10:30 =HOUR(B3) =HOUR(B3) 10 10 Returns 10 because the time is 10:30 AM. Returns 10 because the time is 10:30 AM. 25-12-2024 00:01

=HOUR(B4)



Returns 0, as midnight is hour 0. 25-12-2024 00:01 25-12-2024 00:01 =HOUR(B4) =HOUR(B4) Returns 0, as midnight is hour 0. Returns 0, as midnight is hour 0. Notes:

If the hour_value is not recognized by HOUR function then it will returns the #VALUE! error.
If the hour_value is out of given range and then the HOUR function will returns the #NUM! error. Notes: Notes: If the hour_value is not recognized by HOUR function then it will returns the #VALUE! error.
If the hour_value is out of given range and then the HOUR function will returns the #NUM! error. If the hour_value is not recognized by HOUR function then it will returns the #VALUE! error. hour_value #VALUE! error If the hour_value is out of given range and then the HOUR function will returns the #NUM! error. hour_value #NUM! error That’s it. This tutorial is originally published on How to Use Excel HOUR Function? How to Use Excel HOUR Function?

Walkthroughs, tutorials, guides, and tips. This story will teach you how to do something new or how to do something better.

EOMONTH Function: Simplifying Monthly Financial Calculations in Excel

Excel Dates Showing Numbers? Here's the Quick Fix

View Website Here

Read My Stories

Too Long; Didn't Read

Make resilience your competitive advantage

Quickly Return Hour Values with Excel's HOUR Function!

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

Using the Excel DAYS360 Function for Financial Analysis- A Guide

4 Data Transformations Made Spreadsheet-Easy

5 Excel Features That Can Grow Your Net Worth in No Time

5 Ways to Add Security to Excel & PDF with .NET Document APIs

7 Essential Things in Excel That You Definitely Need to Master

Using the Excel DAYS360 Function for Financial Analysis- A Guide

4 Data Transformations Made Spreadsheet-Easy

5 Excel Features That Can Grow Your Net Worth in No Time

5 Ways to Add Security to Excel & PDF with .NET Document APIs

7 Essential Things in Excel That You Definitely Need to Master

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps