Difference between revisions of "Manuals/calci/TIMEVALUE"
Jump to navigation
Jump to search
| (7 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =TIMEVALUE( | + | <div style="font-size:30px">'''TIMEVALUE (String)'''</div><br/> |
| + | *where <math>String</math> is a text string that represents time | ||
| + | **TIMEVALUE() converts a time in the form of text to a serial number. | ||
| − | |||
| − | |||
| − | |||
== Description == | == Description == | ||
| − | TIMEVALUE( | + | TIMEVALUE(String) |
For Example, | For Example, | ||
| Line 13: | Line 12: | ||
TIMEVALUE("7:00 PM") returns ''0.7916666666642413'' | TIMEVALUE("7:00 PM") returns ''0.7916666666642413'' | ||
| − | *Argument <math> | + | *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> | + | *<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 | + | *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> | + | *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. | *If any arguments are invalid, Calci returns an #ERROR message. | ||
| Line 44: | Line 43: | ||
| class="sshl_f" |0.625 | | class="sshl_f" |0.625 | ||
|} | |} | ||
| + | |||
| + | *TIMEVALUE("next day") = 0.49999999999272404 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=yvyXnw7awEU|280|center|TIMEVALUE}} | ||
== See Also == | == See Also == | ||
| Line 56: | Line 61: | ||
*[http://en.wikipedia.org/wiki/Time Time] | *[http://en.wikipedia.org/wiki/Time Time] | ||
*[http://en.wikipedia.org/wiki/Decimal_time#Scientific_decimal_time Scientific Decimal Time] | *[http://en.wikipedia.org/wiki/Decimal_time#Scientific_decimal_time Scientific Decimal Time] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 05:50, 27 May 2022
TIMEVALUE (String)
- where is a text string that represents time
- TIMEVALUE() converts a time in the form of text to a serial number.
is a text string that represents time
Description
TIMEVALUE(String)
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 |
- TIMEVALUE("next day") = 0.49999999999272404
Related Videos
See Also
References