Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

HOUR

Find hour component from a time value in Excel
Converts a serial number to an hour

Rational

Find hour component from a time value.

Description

The Excel HOUR function returns the hour component of a time value or timestamp between 0 (12:00 A.M.) and 23 (11:59 P.M.). Example; to find hours from the proportion of a day, use =HOUR(0.3) that returns ‘7’ (0.3*24).

Extracting the hour component of a specified time is useful in finding specific hourly event of a date.

Syntax

=HOUR(serial_number)

Parameters

serial_number – A time value

Return Value

An integer representing Hour component

Key Notes

  • Excel HOUR function is used to extract an hour from a specified date or serial number. Enter date with Colon (:) like 12:00.
  • In case of time value display AM/PM, the return value will be between 0 to 23, like 2:00 PM return 14 where 2:00 AM return 2.
  • The Hour function return value in case of argument is integer or decimal. Like 0.6 return value of 0.6*24 = 14, not 14.4 whereas 0.5 return a value of 12 representing the hour component of time value in terms a day.
  • Use SECOND and MINUTE functions to return other two components of Timestamp.

Keep Reading Similar Functions:

Return only the day value of a date in Excel

DAY

The DAY function returns an integer value that represents the day element of a date. I.e.; to extract day component, use =DAY(“08-08-2017”) that returns ‘8’.

Read More »
Returns the seconds component from a time value in Excel

SECOND

The SECOND function returns the second component (a number from 0 to 59). Example, 6:48:15 PM, the SECOND function will return ‘15’.

Read More »
Return date by combining Hour, Minute and Seconds in Excel

TIME

The TIME function returns the time value by merging the three-time components. Example, use =TIME(9,15,35), that may returns “09:15:35”.

Read More »
Returns current date and time in Excel.

NOW

The NOW function returns the serial number of the current date and time. Example; to show the current date and time, use NOW(), empty parenthesis.

Read More »
Find minute component from a timevalue in Excel

MINUTE

The MINUTE function returns the minute component of a time value. For example, with a time of 6:48 PM or text, =MINUTE(time) will return ’48’.

Read More »