calculating run time in a lab.

[#1]

Hi,

I'm trying to calculate the run time for experiments in a lab but when my time exceeds 24 hours it goes wrong.
example:

t1: 2008-10-06 11:40:00
t2: 2008-10-08 11:41:00

run time: 2days 0:01:00 but qlikview gives me this value: 1 00:01:00
the format i use is timestamp "D hh:mm:ss[.fff]"

Is there an easy way to fix this? thx!

[pover]

Are you using the interval function?

Interval(t2-t1,'D hh:mm')

Regards.