topic Re: sum time in QlikView https://community.qlik.com/t5/QlikView/sum-time/m-p/1116471#M368458 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>please go through following</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-16349">Time Difference or Time in Human Readable Format</A></P></BODY></HTML> Sun, 26 Jun 2016 07:13:49 GMT Anonymous 2016-06-26T07:13:49Z sum time https://community.qlik.com/t5/QlikView/sum-time/m-p/1116470#M368457 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i calculte time at the script&nbsp; like this =&nbsp; endtime-starttime</P><P>the result per line is O.K.</P><P>at pivot table i try to sum this feild and the result are wrong.</P><P>when i use interval formt number when the times are in a differnt days the result is also wrong.</P><P>exm:</P><P>starttime - 01/02/16&nbsp; 23:38</P><P>endtime - 02/02/16&nbsp;&nbsp; 00:19</P><P></P><P>i get 41 </P><P>in summeries the result is wrong when the sum is over 24h</P><P>in interval i get -23:19</P><P></P><P>how can i sum this feild good ?</P><P></P><P>thanks'</P><P>yarin.</P></BODY></HTML> Sun, 26 Jun 2016 06:52:22 GMT https://community.qlik.com/t5/QlikView/sum-time/m-p/1116470#M368457 Anonymous 2016-06-26T06:52:22Z Re: sum time https://community.qlik.com/t5/QlikView/sum-time/m-p/1116471#M368458 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>please go through following</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-16349">Time Difference or Time in Human Readable Format</A></P></BODY></HTML> Sun, 26 Jun 2016 07:13:49 GMT https://community.qlik.com/t5/QlikView/sum-time/m-p/1116471#M368458 Anonymous 2016-06-26T07:13:49Z