Time Calculation

[#1]

how do we calculate times in Qlikview? Like - if I start a process on 8/16/2010 8:00:00AM and I finish it at 10:30 that same morning, how can I calculate it to know that it took an hour and a half?

Thanks

[brenner_martina]

Hi polinochka,

the only possibility is to split the time in hours, minutes and seconds, than you can calulate and put it together to a timefield.

[#3]

something like this:

=floor((timestamp#('8/16/2010 10:30:00 AM', 'M/D/YYYY h:mm:ss TT')* 24 * 60)
- (timestamp#('8/16/2010 8:00:00 AM', 'M/D/YYYY h:mm:ss TT') * 24 * 60)) / 60