Manuals/calci/TIMEVALUE

Revision as of 20:46, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TIMEVALUE'''(SomeString) where, '''SomeString''' - is a text string that represents a time in time format(e...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

TIMEVALUE(SomeString)

where,

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


Calci returns the serial number of the text string.


Date information in SomeString is ignored.


TIMEVALUE


Lets see an example in (Column1, Row1)

=TIMEVALUE("1:24 pm")

TIMEVALUE returns 1203449040000.


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 1203449040000
Row2
Row3
Row4
Row5
Row6