writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − *where <math>sn</math> is the time or serial number of time to find the minute value.+ − − − + Line 13:
Line 12: − + − + − +
no edit summary
=MINUTE(sn)=
<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() returns the minute value from the input time.
== Description ==
== Description ==
MINUTE(sn)
MINUTE(Value)
For Example,
For Example,
MINUTE("4:30 AM") ''returns 30''
MINUTE("4:30 AM") ''returns 30''
*Argument <math>sn</math> can be time in the form of text or as a result of any other functions.
*Argument <math>Value</math> can be time in the form of text or as a result of any other functions.
*Argument <math>sn</math> should be enclosed in quotes e.g. "11:00 AM".
*Argument <math>Value</math> should be enclosed in quotes e.g. "11:00 AM".
*If <math>sn</math> is invalid, Calci returns an #ERROR message.
*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'.