Changes

Manuals/calci/TIMEVALUE (view source)

Revision as of 22:34, 11 July 2018

32 bytes added , 22:34, 11 July 2018

no edit summary

Line 1: Line 1:

=TIMEVALUE(SomeString)=

+

<div style="font-size:30px">'''TIMEVALUE (String)'''</div><br/>

−

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

+

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

+

TIMEVALUE() converts a time in the form of text to a serial number.

−

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

== Description ==

−

TIMEVALUE(~~SomeString~~)

+

TIMEVALUE(String)

For Example,

Line 13: Line 15:

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

−

*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).

+

*Argument <math>String</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").

+

*<math>String</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'.

−

*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 <math>String</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.

Devika

writer

6,694

edits