Interval#() evaluates a text expression as a time interval in the format set in the operating system, by default, or in the format specified in the second argument, if supplied.
Syntax:
Interval#(text[, format])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| text |
The text string to be evaluated. |
| format |
String describing the expected input format to use when converting the string to a numeric interval. If omitted, the short date format, time format, and decimal separator set in the operating system are used. |
The interval# function converts a text time interval to a numeric equivalent.
Example:
The examples below assume the following operating system settings:
- Short date format: YY-MM-DD
- Time format: M/D/YY
- Number decimal separator: .
| Example | Result |
|---|---|
| Interval#( A, 'D hh:mm' )
where A='1 09:00' |
1.375 |
