Difference between revisions of "Manuals/calci/MINUTE"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | =MINUTE( | + | <div style="font-size:30px">'''MINUTE (Value)'''</div><br/> |
+ | *where <math>Value</math> is the time or serial number of time to find the minute value. | ||
− | + | MINUTE() converts a input time to a minute. | |
− | |||
− | MINUTE() | ||
== Description == | == Description == | ||
− | MINUTE( | + | MINUTE(Value) |
For Example, | For Example, | ||
Line 13: | Line 12: | ||
MINUTE("4:30 AM") ''returns 30'' | MINUTE("4:30 AM") ''returns 30'' | ||
− | *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 AM". |
− | *If <math> | + | *If <math>Value</math> is invalid, Calci returns an #ERROR message. |
*The output minute value is the value in integers, ranging from '0' to '59'. | *The output minute value is the value in integers, ranging from '0' to '59'. | ||
Revision as of 13:31, 9 July 2018
MINUTE (Value)
- where is the time or serial number of time to find the minute value.
MINUTE() converts a input time to a minute.
Description
MINUTE(Value)
For Example,
MINUTE("4:30 AM") returns 30
- 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 minute value is the value in integers, ranging from '0' to '59'.
Examples
Function | Output |
MINUTE("12:00:00 AM") | 0 |
MINUTE("5:59 PM") | 59 |
MINUTE("2:30") | 30 |
MINUTE("10:33:59 PM") | 33 |
Related Videos
See Also
References