Buzz
This article provides a detailed guide on how to use the HOUR Function to convert a serial number into an hour.
Description: The function returns the hour value within a time value containing hours, minutes, and seconds or a date value with an hour component.
Syntax: HOUR(Serial-number).
Herein:
Serial-number: Represents the time value from which to extract the hour, it is a required parameter.
Example:
Calculate the hour within the following time values:
To calculate the time value 8:45:25, enter the formula: =HOUR(D6).
Press Enter and the result will be 8 hours. Since the specific time is not specified as AM or PM, the function defaults to returning the time value based on the original time to be calculated.
Similarly, time values containing hours and time values converted to decimal numbers are all calculated using the HOUR function.
Above are the usage as well as common scenarios of using the HOUR function.
Wishing you all success!
