Interval - script and chart function

This script function formats 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 ])

 

Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.

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	String	Number
Interval( A ) where A=0.37	09:00:00	0.375
Interval( A ) where A=1.375	33:00:00	1.375
Interval( A, 'D hh:mm' ) where A=1.375	1 09:00	1.375
Interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00	365 09:00	365.375