Quickly Return Hour Values with Excel's HOUR Function!
hackernoon.comHOUR function is used to return the hour as a number between 0 and 23 from a given time. It requires only one argument, serial_number, which must be a valid Excel date or excel time.
HOUR function is used to return the hour as a number between 0 and 23 from a given time.
HOUR Function: A Brief
The HOUR function in Excel extracts the hour from a given time and returns a number between 0 and 23. For example, if the time is 10:30 AM, the HOUR function will return 10. You can use this function to return the hour value in a cell.
|
Objective |
Value Returned by function |
|---|---|
|
Aim to get the Hour value as Number |
HOUR Function will return a numeric values from the input hour value. |
HOUR Function: A Syntax:
=HOUR(hour_value)
- hour_value: It should be a valid excel hour ...
Copyright of this story solely belongs to hackernoon.com . To see the full text click HERE