Difference between revisions of "Manuals/calci/SECOND"
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 | + | <sub><div style="font-size:30px">'''SECOND (Value)'''</div><br/> |
| + | *where <math>Value</math> is the time or serial number of time to find the seconds value. | ||
| + | **SECOND(), converts a serial number to a second. | ||
| − | + | == Description == | |
| − | + | SECOND(Value) | |
| − | |||
| − | |||
| − | + | For Example, | |
| − | + | SECOND("3:45:20 AM") ''returns 20'' | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | < | + | *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:00 AM". | ||
| + | *If <math>Value</math> is invalid, Calci returns an #ERROR message. | ||
| + | *The output seconds value is the value in integers, ranging from '0' to '59'. | ||
| − | + | == Examples == | |
| − | |||
| − | |||
| − | + | <div id="6SpaceContent" class="zcontent" align="left"> | |
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| − | -- | + | |- class="even" |
| − | + | | class=" " | '''Function''' | |
| + | | class=" " | '''Output''' | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="sshl_f" |SECOND("12:00:00 AM") | ||
| + | | class="sshl_f" |0 | ||
| + | |||
| + | |- class="even" | ||
| + | | class="sshl_f" |SECOND("5:59 PM") | ||
| + | | class="sshl_f" |0 | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" |SECOND("2:30:44") | ||
| + | | class="sshl_f" |44 | ||
| − | + | |- class="even" | |
| + | | class="sshl_f" |SECOND("10:33:59 PM") | ||
| + | | class="sshl_f" |59 | ||
| + | |} | ||
| − | + | ==Related Videos== | |
| − | |||
| − | |||
| − | + | {{#ev:youtube|Qpmg2vKwvbc|280|center|SECOND}} | |
| − | + | == See Also == | |
| − | |||
| − | |||
| − | + | *[[Manuals/calci/HOUR | HOUR]] | |
| + | *[[Manuals/calci/MINUTE | MINUTE]] | ||
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Second Second] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | ||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 14:15, 22 August 2018
SECOND (Value)
- where is the time or serial number of time to find the seconds value.
- SECOND(), converts a serial number to a second.
is the time or serial number of time to find the seconds value.
Description
SECOND(Value)
For Example,
SECOND("3:45:20 AM") returns 20
- 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:00 AM".
- If is invalid, Calci returns an #ERROR message.
- The output seconds value is the value in integers, ranging from '0' to '59'.
Examples
| Function | Output |
| SECOND("12:00:00 AM") | 0 |
| SECOND("5:59 PM") | 0 |
| SECOND("2:30:44") | 44 |
| SECOND("10:33:59 PM") | 59 |
Related Videos
See Also
References