Difference between revisions of "Manuals/calci/HOUR"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''HOUR (Value)'''</div><br/> |
| − | + | *where <math>Value</math> is the time to find the hour value. | |
| + | **HOUR() Converts a serial number to an hour. | ||
| − | + | == Description == | |
| − | |||
| − | |||
| − | + | HOUR(Value) | |
| − | + | For Example, | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | HOUR("3:25 AM") ''returns 3'' | |
| − | < | + | *Argument <math>Value</math> can be time in the form of text or as a result of any other functions. |
| − | + | *Argument <math>Value</math> should be enclosed in quotes e.g. "11:00 AM". | |
| − | < | + | *If <math>Value</math> 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 == | |
| − | + | <div id="6SpaceContent" class="zcontent" align="left"> | |
| − | |||
| − | <div id=" | ||
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| + | |- class="even" | ||
| + | | class=" " | '''Function''' | ||
| + | | class=" " | '''Output''' | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" |HOUR("12:00:00 AM") | ||
| + | | class="sshl_f" |0 | ||
| − | + | |- class="even" | |
| − | - | + | | class="sshl_f" |HOUR("4:50 PM") |
| − | + | | class="sshl_f" |16 | |
| − | + | |- class="odd" | |
| + | | class="sshl_f" |HOUR("11:30") | ||
| + | | class="sshl_f" |11 | ||
| − | + | |- class="even" | |
| − | - | + | | class="sshl_f" |HOUR("10:00:00 PM") |
| − | + | | class="sshl_f" |22 | |
| + | |} | ||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|DLno3b-Xsmo|280|center|HOUR}} | |
| − | + | == See Also == | |
| − | + | *[[Manuals/calci/MINUTE | MINUTE]] | |
| + | *[[Manuals/calci/SECOND | SECOND]] | ||
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Hour Hour] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 13:53, 22 August 2018
HOUR (Value)
- where is the time to find the hour value.
- HOUR() Converts a serial number to an hour.
is the time to find the hour value.
Description
HOUR(Value)
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