topic Re: Interval function in QlikView https://community.qlik.com/t5/QlikView/Interval-function/m-p/1260834#M851186 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Interval(Sum(#Uren)/24 - Sum([#Uren NB])/24, 'dd:hh')</STRONG></P></BODY></HTML> Thu, 09 Mar 2017 13:51:28 GMT sunny_talwar 2017-03-09T13:51:28Z Interval function https://community.qlik.com/t5/QlikView/Interval-function/m-p/1260833#M851185 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>I'm having a problem with the interval function.</P><P></P><P>The formula is as following:</P><P>SUM(A)/24 - SUM(B)/24 = dd:hh</P><P></P><P>To do this i have the following definition:</P><P></P><P>INTERVAL(SUM(#Uren)/24, 'dd:hh')</P><P>-</P><P>Interval(SUM([#Uren NB])/24,'dd:hh')</P><P></P><P>The problem is that the outcome isn't formatted as dd:hh but as ###,##.</P><P></P><P>What am I doing wrong?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Interval-function/m-p/1260833#M851185 tomgrouwe 2020-11-25T16:16:04Z Re: Interval function https://community.qlik.com/t5/QlikView/Interval-function/m-p/1260834#M851186 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Interval(Sum(#Uren)/24 - Sum([#Uren NB])/24, 'dd:hh')</STRONG></P></BODY></HTML> Thu, 09 Mar 2017 13:51:28 GMT https://community.qlik.com/t5/QlikView/Interval-function/m-p/1260834#M851186 sunny_talwar 2017-03-09T13:51:28Z Re: Interval function https://community.qlik.com/t5/QlikView/Interval-function/m-p/1260835#M851187 <HTML><HEAD></HEAD><BODY><P>Worked! Thank you very much</P></BODY></HTML> Thu, 09 Mar 2017 13:54:43 GMT https://community.qlik.com/t5/QlikView/Interval-function/m-p/1260835#M851187 tomgrouwe 2017-03-09T13:54:43Z