topic Adding times from an Excel sheet in QlikView https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848924#M993848 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a list of times importing from an Excel sheet.</P><P></P><P>LOGGED_IN_DURATION</P><P>06:52:42</P><P>00:54:16</P><P>05:45:09</P><P>02:11:45</P><P>07:49:21</P><P>08:00:02</P><P></P><P>Formatted in custom (hh:mm:ss)</P><P></P><P>If I add the field to a statistics box and sum I get the answer 07:33:15 (format overriden to TIME)</P><P>How is this so? If I filter out the last time of 08:00:02 it does add up correctly. but including this does skew the results.</P><P></P><P>Many thanks in advance</P></BODY></HTML> Fri, 10 Jul 2015 10:17:10 GMT Anonymous 2015-07-10T10:17:10Z Adding times from an Excel sheet https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848924#M993848 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a list of times importing from an Excel sheet.</P><P></P><P>LOGGED_IN_DURATION</P><P>06:52:42</P><P>00:54:16</P><P>05:45:09</P><P>02:11:45</P><P>07:49:21</P><P>08:00:02</P><P></P><P>Formatted in custom (hh:mm:ss)</P><P></P><P>If I add the field to a statistics box and sum I get the answer 07:33:15 (format overriden to TIME)</P><P>How is this so? If I filter out the last time of 08:00:02 it does add up correctly. but including this does skew the results.</P><P></P><P>Many thanks in advance</P></BODY></HTML> Fri, 10 Jul 2015 10:17:10 GMT https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848924#M993848 Anonymous 2015-07-10T10:17:10Z Re: Adding times from an Excel sheet https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848925#M993849 <HTML><HEAD></HEAD><BODY><P>Not sure what you are getting and what you intend to get. You want to see a different sum or format in the statistic box object??</P></BODY></HTML> Fri, 10 Jul 2015 10:26:41 GMT https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848925#M993849 sunny_talwar 2015-07-10T10:26:41Z Re: Adding times from an Excel sheet https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848926#M993850 <HTML><HEAD></HEAD><BODY><P>Your sum of hours is greater then 24 hours - you need to divide your result / 24 hours to get in days or you used interval() which give you as result 31 h ...</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 10 Jul 2015 10:31:42 GMT https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848926#M993850 marcus_sommer 2015-07-10T10:31:42Z Re: Adding times from an Excel sheet https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848927#M993851 <HTML><HEAD></HEAD><BODY><P>See if this is what you want:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92446_Capture.PNG" style="height: 438px; width: 620px;" /></P></BODY></HTML> Fri, 10 Jul 2015 10:35:16 GMT https://community.qlik.com/t5/QlikView/Adding-times-from-an-Excel-sheet/m-p/848927#M993851 sunny_talwar 2015-07-10T10:35:16Z