Manuals/calci/TIMEVALUE

TIMEVALUE (String)

• where $String$ is a text string that represents time
  • TIMEVALUE() converts a time in the form of text to a serial number.

Description

TIMEVALUE(String)

For Example,

TIMEVALUE("7:00 PM") returns 0.7916666666642413

• Argument $String$ 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).
• $String$ 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 $String$ 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.

Examples

Function	Output
TIMEVALUE("4:30:30 AM")	0.18784722222335404
TIMEVALUE("15:00")	0.625
TIMEVALUE("10:00 PM")	0.9166666666642413
TIMEVALUE("10-DEC-2000 15:00")	0.625

• TIMEVALUE("next day") = 0.49999999999272404

Related Videos

TIMEVALUE

See Also

• HOUR
• MINUTE
• SECOND
• TIME

References

• Time
• Scientific Decimal Time

• List of Main Z Functions

• Z3 home