Home Application Office information

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

HOUR function: The function returns the hour value in the time value hour minute second or the date value containing the hour.

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:

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

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

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

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.

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

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

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

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

Good luck!

You've just finished reading the article "HOUR function - The function converts a serial number into an hour in Excel" edited by the TipsMake team. You can save hour-function-the-function-converts-a-serial-number-into-an-hour-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV TINV function - The function returns the inverse of the Student's t-distribution in Excel
NEXT » Compare WEEKDAY and WEEKNUM functions in Excel
Read more