Difference between revisions of "Manuals/calci/SECOND"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =SECOND( | + | <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. | |
| − | *where <math> | + | **SECOND(), converts a serial number to a second. |
| − | |||
| − | SECOND() | ||
== Description == | == Description == | ||
| − | SECOND( | + | SECOND(Value) |
For Example, | For Example, | ||
| Line 13: | Line 11: | ||
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'. | ||
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