interval function?

[#1]

what is interval function work  i am not talking about interval  match

[alexandros17]

Take a look in the help, it seems clear, otherwise give me an example of what is not clear

[PrashantSangle · Accepted solution]

Hi,

The interval 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. Intervals may be formatted as a

time, as days or as a combination of days, hours, minutes, seconds and fractions

of seconds.

Syntax:

Interval(expression[,Format Code])

Example:

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00

returns:

String:365 09:00

Number : 365.375

interval( A ) where A=1.375

returns:

String:09:00:00

Number : 0.375

Regards

[senpradip007]

The interval 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. Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns 365 09:00

[#5]

if u convert A into string u will get 365?

incase b is  also near to same right?

can u give clear explination i am confused resulting output  but i understood work of interval