Difference between revisions of "Manuals/calci/SECOND"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=SECOND(sn)= | =SECOND(sn)= | ||
| + | <sub><div style="font-size:30px">'''SECOND (Value)'''</div><br/> | ||
| − | *where <math> | + | *where <math>Value</math> is the time or serial number of time to find the seconds value. |
| − | SECOND() | + | SECOND(), converts a serial number to a second. |
== Description == | == Description == | ||
| − | SECOND( | + | SECOND(Value) |
For Example, | For Example, | ||
| Line 13: | Line 14: | ||
SECOND("3:45:20 AM") ''returns 20'' | SECOND("3:45:20 AM") ''returns 20'' | ||
| − | *Argument <math> | + | *Argument <math>Value</math> can be time in the form of text or as a result of any other functions. |
| − | *Argument <math> | + | *Argument <math>Value</math> should be enclosed in quotes e.g. "11:00:00 AM". |
| − | *If <math> | + | *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'. | *The output seconds value is the value in integers, ranging from '0' to '59'. | ||
Revision as of 15:53, 11 July 2018
SECOND(sn)
SECOND (Value)
- where is the time or serial number of time to find the seconds value.
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 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