The following article details how to use the HOUR function, the function converts a serial number into an hour.
Description: The function returns the hour value in time, hour, second, or date value that contains the hour.
Syntax : HOUR (Serial-number) .
Inside:
Serial-number : This is the time value that you want to get separate time value, is a required parameter.
For example:
Count the hours in the following time values:
To calculate the time value 8:45:25 enter the formula: = HOUR (D6) .
Pressing Enter results time it is 8 hours. Because that time is not specified as AM or PM, the function returns the time value by default based on the initial time to be calculated.
Similarly, the date time value containing the hour and the time value converted to decimal are calculated using the HOUR function .
The above is how to use as well as the case to use the HOUR function .
Good luck!