HOUR function - The function returns the hour of a time value in Excel
The following article introduces you to the HOUR function - one of the functions in the date and time group is very popular in Excel.
Description: The function returns the hour value of a time value, the hour is returned as an integer.
Syntax : HOUR (serial_number)
Where: serial_number is the time value want to count, is a required parameter.
Attention:
- Where serial_number value is a date value does not specify the time the function will return the value #VALUE !.
- The time value is part of the date value and it is expressed as a decimal.
For example:
Calculate the hour value in the time value in the following table:
- In the cell to calculate enter the formula : = HOUR (E7).
- Press Enter -> 25% of 24 hours is:
- Similarly copying the formula for the remaining values results:
- Where the value seri_number does not contain the hour unit -> the function returns the #VALUE! Error value
Above are instructions and some specific examples in working with HOUR function in Excel.
Good luck!
You should read it
- HOUR function - The function converts a serial number into an hour in Excel
- TIME function - Function returns decimal numbers for a specific time value in Excel
- DATEPART function in SQL Server
- DATENAME function in SQL Server
- How to Convert Time from 24-Hour to 12-Hour
- NOW function - The function returns the current date and time in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- SECOND function - The function returns the second part of a time value in Excel
- POISSON function - The function returns the Poisson distribution in Excel
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- CHISQ.TEST function - The function returns the independence test in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python