topic Time Calculation in QlikView https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/164723#M37317 <HTML><HEAD></HEAD><BODY><P>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?</P><P>Thanks</P></BODY></HTML> Tue, 17 Aug 2010 15:57:41 GMT 2010-08-17T15:57:41Z Time Calculation https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/164723#M37317 <HTML><HEAD></HEAD><BODY><P>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?</P><P>Thanks</P></BODY></HTML> Tue, 17 Aug 2010 15:57:41 GMT https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/164723#M37317 2010-08-17T15:57:41Z AW:Time Calculation https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/164724#M37318 <HTML><HEAD></HEAD><BODY><P>Hi polinochka,</P><P>the only possibility is to split the time in hours, minutes and seconds, than you can calulate and put it together to a timefield.</P></BODY></HTML> Tue, 17 Aug 2010 16:44:50 GMT https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/164724#M37318 brenner_martina 2010-08-17T16:44:50Z Time Calculation https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/164725#M37319 <HTML><HEAD></HEAD><BODY><P>something like this:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=floor((timestamp#('8/16/2010 10:30:00 AM', 'M/D/YYYY h:mm:ss TT')* 24 * 60)<BR />- (timestamp#('8/16/2010 8:00:00 AM', 'M/D/YYYY h:mm:ss TT') * 24 * 60)) / 60</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 17 Aug 2010 16:57:29 GMT https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/164725#M37319 2010-08-17T16:57:29Z