Changes

Manuals/calci/TIMEVALUE (view source)

Revision as of 13:09, 27 December 2013

691 bytes removed , 13:09, 27 December 2013

no edit summary

Line 1: Line 1: −

~~<div id~~=~~"6SpaceContent" class~~=~~"zcontent" align="left">~~

+

=TIMEVALUE(SomeString)=

−

~~'''TIMEVALUE'''(~~SomeString)

+

*where <math>SomeString</math> is a text string that represents time

−

~~where,~~

+

TIMEVALUE() returns the decimal representation of time entered by a text string.

−

~~'''SomeString''' - is a text string that represents a time in time format(e.g. "3:30 PM")~~

+

== Description ==

−

~~</div>~~

+

TIMEVALUE(SomeString)

−

~~----~~

−

~~<div id="1SpaceContent" class="zcontent" align="left">~~

−

~~Calci returns the serial number of the text string.~~

+

For Example,

−

~~</div>~~

+

TIMEVALUE("7:00 PM") returns ''0.7916666666642413''

−

~~----~~

−

~~<div id=~~"~~7SpaceContent~~" ~~class="zcontent" align="left">~~

−

~~Date information~~ in SomeString is ignored.

+

*Argument <math>SomeString</math> can be the time in a time format, considering a 24 hour clock from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).

+

*<math>SomeString</math> should be enclosed in quotation marks (e.g. "12:00 PM" or "20:30").

+

*The decimal output of time value is in the range from '0' to '0.999988426'. e.g. 12:00 PM is half of a day, represented as '0.5' or '0.25'.

+

*If <math>SomeString</math> is entered in day time format, date value is ignored. e.g. In "4-FEB-2010 4:00 PM", date value is ignored.

+

*If any arguments are invalid, Calci returns an #ERROR message.

−

~~</div>~~

+

== Examples ==

−

~~----~~

−

~~<div id~~=~~"12SpaceContent" class~~=~~"zcontent" align~~=~~"left"><div class~~=~~"ZEditBox" align="left">~~

−

~~TIMEVALUE~~

+

−

~~<font size="6"></font>~~

−

~~</div></div>~~

−

~~----~~

−

~~<div id="8SpaceContent" class="zcontent" align="left">~~

−

~~Lets see an example in (Column1, Row1)~~

−

~~<nowiki>=TIMEVALUE("1:24 pm")</nowiki>~~

−

~~TIMEVALUE returns 1203449040000.~~

−

~~</div>~~

−

~~----~~

−

~~<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>~~

−

~~----~~

−

~~<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>~~

−

~~----~~

−

~~<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>~~

−

~~----~~

−

~~<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>~~

−

~~----~~

−

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

−

| class=" " |

+

| class=" " | '''Function'''

−

| ~~Column1~~

+

| class=" " | '''Output'''

−

~~| Column2~~

+

−

| ~~Column3~~

−

~~| Column4~~

|- class="odd"

−

~~| class=" " | Row1~~

+

| class="sshl_f" |TIMEVALUE("4:30:30 AM")

−

| class="sshl_f" | ~~1203449040000~~

+

| class="sshl_f" |0.18784722222335404

−

~~| class=~~" " |

+

−

| class=" " |

−

~~| class=" " |~~

|- class="even"

−

| class=" " | ~~Row2~~

+

| class="sshl_f" |TIMEVALUE("15:00")

−

~~| class=~~" ~~SelectTD ChangeBGColor SelectTD~~" |

+

| class="sshl_f" |0.625

−

<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>

+

−

| class="sshl_f" |

−

~~| class=" " |~~

−

~~| class=" " |~~

|- class="odd"

−

~~| Row3~~

+

| class="sshl_f" |TIMEVALUE("10:00 PM")

−

~~| class=" " |~~

+

| class="sshl_f" |0.9166666666642413

−

~~| class=" " |~~

+

−

~~| class=" " |~~

−

~~| class=" " |~~

−

~~|- class="even"~~

−

~~| Row4~~

−

~~| class=" " |~~

−

| class=" " |

−

~~| class=~~" " |

−

| class=" " |

−

~~|- class="odd"~~

−

~~| class=" " | Row5~~

−

~~| class=" " |~~

−

~~| class=" " |~~

−

~~| class=" " |~~

−

~~| class=" " |~~

|- class="even"

−

~~| Row6~~

+

| class="sshl_f" |TIMEVALUE("10-DEC-2000 15:00")

−

~~| class=" " |~~

+

| class="sshl_f" |0.625

−

| class=" " |

−

~~| class=~~" " |

−

| class=" " |

|}

−

~~<div align~~=~~"left">~~[[~~Image~~:~~calci1~~.~~gif~~]]</~~div><~~/~~div>~~

+

== See Also ==

−

~~----~~

+

*[[Manuals/calci/HOUR | HOUR]]

+

*[[Manuals/calci/MINUTE | MINUTE]]

+

*[[Manuals/calci/SECOND | SECOND]]

+

*[[Manuals/calci/TIME | TIME]]

+

==References==

+

*[http://en.wikipedia.org/wiki/Time Time]

+

*[http://en.wikipedia.org/wiki/Decimal_time#Scientific_decimal_time Scientific Decimal Time]

Swapna

writer

2,661

edits