topic Sum time duration in QlikView https://community.qlik.com/t5/QlikView/Sum-time-duration/m-p/868663#M1001292 <HTML><HEAD></HEAD><BODY><P>Hi everyone,&nbsp; </P><P></P><P>I am new in qlikview and I have one problem with adding different durations times in this format 'YYYY/MM/DD HH:MM:SS.fff'. In this field I have years, months and days with 0 (i.e 0/0/0 03:01:00)&nbsp; and I do believe this is the issue. Can you help me solved it?</P><P>Thanks in advance..</P><P></P><P>Best regards</P><P>José João Grave</P></BODY></HTML> Wed, 10 Jun 2015 23:16:20 GMT 2015-06-10T23:16:20Z Sum time duration https://community.qlik.com/t5/QlikView/Sum-time-duration/m-p/868663#M1001292 <HTML><HEAD></HEAD><BODY><P>Hi everyone,&nbsp; </P><P></P><P>I am new in qlikview and I have one problem with adding different durations times in this format 'YYYY/MM/DD HH:MM:SS.fff'. In this field I have years, months and days with 0 (i.e 0/0/0 03:01:00)&nbsp; and I do believe this is the issue. Can you help me solved it?</P><P>Thanks in advance..</P><P></P><P>Best regards</P><P>José João Grave</P></BODY></HTML> Wed, 10 Jun 2015 23:16:20 GMT https://community.qlik.com/t5/QlikView/Sum-time-duration/m-p/868663#M1001292 2015-06-10T23:16:20Z Re: Sum time duration https://community.qlik.com/t5/QlikView/Sum-time-duration/m-p/868664#M1001293 <HTML><HEAD></HEAD><BODY><P>Just use the time part:</P><P></P><P>=sum(interval#( right( YourField, 8), 'hh:mm:ss'))</P></BODY></HTML> Fri, 19 Jun 2015 18:30:31 GMT https://community.qlik.com/t5/QlikView/Sum-time-duration/m-p/868664#M1001293 swuehl 2015-06-19T18:30:31Z Re: Sum time duration https://community.qlik.com/t5/QlikView/Sum-time-duration/m-p/868665#M1001294 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution could be also:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14347512830429295 jive_text_macro" jivemacro_uid="_14347512830429295"> <P>=Interval(Sum(SubField(duration_txt,' ',-1)))</P> </PRE><P></P><P><IMG alt="QlikCommunity_Thread_167858_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90144_QlikCommunity_Thread_167858_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 19 Jun 2015 22:01:55 GMT https://community.qlik.com/t5/QlikView/Sum-time-duration/m-p/868665#M1001294 MarcoWedel 2015-06-19T22:01:55Z