writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">+ − Syntax+ − </div></div>+ − ---- − <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify"> − Examples+ − </div></div>+ − ---- − <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div> − ---- − <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify"> − <font size="5">Description</font>+ − </div></div>+ − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6" face="Arial, sans-serif"><font size="6">'''MINUTE '''</font></font> − '''<font size="6" face="Arial"></font>'''+ + + + − </div></div>+ − ---- − <div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − '''<font color="#484848"><font face="Arial, sans-serif"><font size="2">MINUTE</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(sn</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>'''+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">where sn''' '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">is the time that contains the minute which is to be find. </font></font></font>+ + + + − </div></div>+ − + − <div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives the minutes of a time value. </font></font></font>+ + + − </div></div>+ − + − <div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example in Column1Row1</font></font></font>+ − + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">C1R1= 10:30:00 AM</font></font></font>+ + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=MINUTE((C1R1) is 30</font></font></font>+ − </div></div>+ − ----+ − <div id="5SpaceContent" class="zcontent" align="left"> − {| id="TABLE6" class="SpreadSheet blue"+ − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class=" " | 10:30:00 AM − | class="sshl_f" | 30 − | class=" " | − | class=" " | − |- class="even" − | class=" " | Row2 − | class=" " | − | class="f52543 " | − | class=" SelectTD" | − <div id="5Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="5Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class=" " | − |- class="odd" − | Row3 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |} − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----
no edit summary
=MINUTE(sn)=
*where <math>sn</math> is the time or serial number of time to find the minute value.
MINUTE() returns the minute value from the input time.
== Description ==
MINUTE(sn)
For Example,
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>sn</math> should be enclosed in quotes e.g. "11:00 AM".
*If <math>sn</math> is invalid, Calci returns an #ERROR message.
*The output minute value is the value in integers, ranging from '0' to '59'.
== Examples ==
<div id="6SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " | '''Function'''
| class=" " | '''Output'''
|- class="odd"
----
| class="sshl_f" |MINUTE("12:00:00 AM")
| class="sshl_f" |0
|- class="even"
| class="sshl_f" |MINUTE("5:59 PM")
| class="sshl_f" |59
|- class="odd"
----
| class="sshl_f" |MINUTE("2:30")
| class="sshl_f" |30
|- class="even"
| class="sshl_f" |MINUTE("10:33:59 PM")
| class="sshl_f" |33
|}
== See Also ==
*[[Manuals/calci/HOUR | HOUR]]
*[[Manuals/calci/SECOND | SECOND]]
==References==
*[http://en.wikipedia.org/wiki/Minute Minute]