Difference between revisions of "Manuals/calci/TIMEVALUE"
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Revision as of 21:46, 24 October 2013
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 |