Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Time Calculation

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

2 Replies
Partner
Partner

AW:Time Calculation

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.

Not applicable

Time Calculation

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