writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 15:
Line 15: − +
Manuals/calci/TIMEVALUE (view source)
Revision as of 13:11, 27 December 2013
, 13:11, 27 December 2013no edit summary
*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>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").
*<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'.
*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>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.
*If any arguments are invalid, Calci returns an #ERROR message.