Manuals/calci/TIMEVALUE

From ZCubes Wiki
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)
Jump to navigation Jump to search

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
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/TIMEVALUE&oldid=630"