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:

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 »
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 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 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 »
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 »