Manuals/calci/TIMEVALUE
Jump to navigation
Jump to search
TIMEVALUE(SomeString)
- where is a text string that represents time
TIMEVALUE() returns the decimal representation of time entered by a text string.
Description
TIMEVALUE(SomeString)
For Example,
TIMEVALUE("7:00 PM") returns 0.7916666666642413
- Argument 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).
- 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 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 |
Related Videos
See Also
References