Excel HOUR() Function

Excel HOUR() Function

The HOUR() function in excel converts a serial number to an hour (0 - 23).

Syntax

HOUR(SERIAL_NUMBER)

Parameter

SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract the hour.

Category

Date & Time

Return

This function returns the hour from 0 to 23

Example 1

Objective: Identify today's weekday number basis different return_type value

Col A Result Formula
11/12/2019 22:06 22  =HOUR(A15)
10:15 AM 10  =HOUR(A16)
11:59 PM 23  =HOUR(A17)

Example 2

Objective: Extract Hour from below given dummy entries

Dummy Entries Result Formula
1-Jan-16 5:37:39 PM 17  =HOUR(A15)
0.46347 11  =HOUR(A16)
23-Feb-18 0  =HOUR(A17)

Example 3

Objective: Return current hour value

Result Formula
17  =HOUR(NOW())



ADVERTISEMENT
ADVERTISEMENT