Interval# - script and chart function

This function evaluates the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used.

Syntax:  

Interval#(expression [ , format-code ])

 

The interval# function generally behaves just like the time# function but while times can never be greater than 23:59:59 (numeric value 0.99999) or smaller than 00:00:00 (numeric value 0.00000) an interval may have any value.

Examples and results:

The examples below assume the following operating system settings:

Short date format:	YY-MM-DD
Time format:	hh:mm:ss
Number decimal separator:	.

Example		Result
Interval#( A, 'D hh:mm' ) where A=1 09:00	String:	1 09:00
	Number:	1.375
Interval#( A-B ) where A=97-08-06 09:00:00 and B=97-08-05 00:00:00	String:	1.375
	Number:	1.375