Find hour component from a time value.
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.
serial_number – A time value
An integer representing Hour component
- 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.