Difference between revisions of "Manuals/calci/HOUR"
Jump to navigation
Jump to search
Line 56: | Line 56: | ||
*[http://en.wikipedia.org/wiki/Hour Hour] | *[http://en.wikipedia.org/wiki/Hour Hour] | ||
+ | |||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Revision as of 06:20, 13 March 2017
HOUR(sn)
- where is the time to find the hour value.
HOUR() returns the hour value from the input time.
Description
HOUR(sn)
For Example,
HOUR("3:25 AM") returns 3
- Argument can be time in the form of text or as a result of any other functions.
- Argument should be enclosed in quotes e.g. "11:00 AM".
- If is invalid, Calci returns an #ERROR message.
- The output hour value is the value in integers considering a 24 hour clock. It ranges from '0' for 12:00:00 AM to '23' for 11:00:00 PM.
Examples
Function | Output |
HOUR("12:00:00 AM") | 0 |
HOUR("4:50 PM") | 16 |
HOUR("11:30") | 11 |
HOUR("10:00:00 PM") | 22 |
Related Videos
See Also
References