Difference between revisions of "Manuals/calci/SECOND"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
<sub><div style="font-size:30px">'''SECOND (Value)'''</div><br/> | <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>Value</math> is the time or serial number of time to find the seconds value. | ||
| − | + | **SECOND(), converts a serial number to a second. | |
| − | SECOND(), converts a serial number to a second. | ||
== Description == | == Description == | ||
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