HOUR function - The function converts a serial number into an hour in Excel

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:

HOUR function - The function converts a serial number into an hour in Excel Picture 1

To calculate the time value 8:45:25 enter the formula: = HOUR (D6) .

HOUR function - The function converts a serial number into an hour in Excel Picture 2

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.

HOUR function - The function converts a serial number into an hour in Excel Picture 3

Similarly, the date time value containing the hour and the time value converted to decimal are calculated using the HOUR function .

HOUR function - The function converts a serial number into an hour in Excel Picture 4

The above is how to use as well as the case to use the HOUR function .

Good luck!