Hour()
Category: Time
Syntax: Hour ( time ) |
Parameters:
timeAny valid time value or expression that returns a valid time value.
Data type returned: Number
Description:
The Hour() function returns an integer representing the number of hours specified by the time parameter.
When its parameter represents a specific time of day, the Hour() function returns a value from 0 to 23. To map this into the more familiar 1 to 12 range, you can use the following formula:
Mod ( Hour (time) -1; 12 ) + 1
The Hour() function can return an integer value outside of the 0 to 23 range when its parameter represents a duration rather than a specific time of day. For instance, Hour ("65:12:53") returns 65.
Examples:
Function | Results |
|---|---|
Hour ("10:45:20") | Returns 10. |
Hour ("12:15 am") | Returns 0. |
Hour ("11:15 pm") | Returns 23. |
Hour ( Get(CurrentTime )) | Will return a value from 0 to 23. |
Категории