topic Sum up time in QlikView https://community.qlik.com/t5/QlikView/Sum-up-time/m-p/383382#M1166007 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif';">I have a CSV file containing activities where each activity has a time associated with it in minutes and seconds (two separate columns). I want to sum up the time for all the activities and the total time will be several hundred hours and should be shown as hhh:mm:ss. I started to do a lot of Div and Mod of the sums of minutes and seconds, respectively, to get the total sum, but isn't there some easier way to accomplish this?</SPAN></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT 2020-11-20T18:02:30Z Sum up time https://community.qlik.com/t5/QlikView/Sum-up-time/m-p/383382#M1166007 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif';">I have a CSV file containing activities where each activity has a time associated with it in minutes and seconds (two separate columns). I want to sum up the time for all the activities and the total time will be several hundred hours and should be shown as hhh:mm:ss. I started to do a lot of Div and Mod of the sums of minutes and seconds, respectively, to get the total sum, but isn't there some easier way to accomplish this?</SPAN></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Sum-up-time/m-p/383382#M1166007 2020-11-20T18:02:30Z Re: Sum up time https://community.qlik.com/t5/QlikView/Sum-up-time/m-p/383383#M1166008 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You probably may fin the answer in the following thread.</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/message/66084#66084" title="http://community.qlik.com/message/66084#66084">http://community.qlik.com/message/66084#66084</A></P><P></P><P>Regards,</P><P></P><P>Gerrit</P></BODY></HTML> Tue, 04 Sep 2012 15:01:54 GMT https://community.qlik.com/t5/QlikView/Sum-up-time/m-p/383383#M1166008 2012-09-04T15:01:54Z