Discussion Board for collaboration related to QlikView App Development.
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?
the only possibility is to split the time in hours, minutes and seconds, than you can calulate and put it together to a timefield.
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