Manuals/calci/MINUTE - Revision history

Devika at 20:12, 22 August 2018

2018-08-22T20:12:44Z

Devika at 19:31, 9 July 2018

2018-07-09T19:31:05Z

Jayaram at 12:21, 13 March 2017

2017-03-13T12:21:02Z

Swapna at 19:43, 15 June 2015

2015-06-15T19:43:46Z

Swapna at 19:33, 23 December 2013

2013-12-23T19:33:39Z

MassBot1: Created page with "
Syntax
----

2013-10-25T02:40:17Z

Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=..."

New page
<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>
----

@@ Line 1: / Line 1: @@
 <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.
 == Description ==

@@ Line 1: / Line 1: @@
-=MINUTE(sn)=
+<div style="font-size:30px">'''MINUTE (Value)'''</div><br/>
-*where <math>sn</math> is the time or serial number of time to find the minute value.
+MINUTE() converts a input time to a minute.
 == Description ==
-MINUTE(sn)
+MINUTE(Value)
 For Example,
@@ Line 13: / Line 12: @@
 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'.

← Older revision		Revision as of 12:21, 13 March 2017
Line 56:		Line 56:

	*[http://en.wikipedia.org/wiki/Minute Minute]		*[http://en.wikipedia.org/wiki/Minute Minute]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 43: / Line 43: @@
 | class="sshl_f" |33
 |}
 == See Also ==

@@ Line 1: / Line 1: @@
-<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+=MINUTE(sn)=
-Syntax
+*where <math>sn</math> is the time or serial number of time to find the minute value.
-</div></div>
+MINUTE() returns the minute value from the input time.
-Examples
+== Description ==
-</div></div>
+MINUTE(sn)
-<font size="5">Description</font>
+For Example,
-</div></div>
+MINUTE("4:30 AM") ''returns 30''
-'''<font size="6" face="Arial"></font>'''
+*Argument <math>sn</math> can be time in the form of text or as a result of any other functions.
-</div></div>
+== Examples ==
-'''<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>'''
+<div id="6SpaceContent" class="zcontent" align="left">
-<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>
+{| id="TABLE3" class="SpreadSheet blue"
-</div></div>
+|- class="odd"
-----
+| class="sshl_f" |MINUTE("12:00:00 AM")
-<div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
+| class="sshl_f" |0
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives the minutes of a time value. </font></font></font>
+|- class="even"
-</div></div>
+|- class="odd"
-----
+| class="sshl_f" |MINUTE("2:30")
-<div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
+| class="sshl_f" |30
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example in Column1Row1</font></font></font>
+|- class="even"
+| class="sshl_f" |MINUTE("10:33:59 PM")
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">C1R1= 10:30:00 AM</font></font></font>
+| class="sshl_f" |33
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=MINUTE((C1R1) is 30</font></font></font>
+== See Also ==
-</div></div>
+*[[Manuals/calci/HOUR | HOUR]]
-----
+*[[Manuals/calci/SECOND | SECOND]]
-{| id="TABLE6" class="SpreadSheet blue"
+==References==
-<div align="left">[[Image:calci1.gif]]</div></div>
+*[http://en.wikipedia.org/wiki/Minute Minute]