topic Re: How to substract time and date fields. in QlikView https://community.qlik.com/t5/QlikView/How-to-substract-time-and-date-fields/m-p/1001516#M467807 <HTML><HEAD></HEAD><BODY><P>Thanks works great.</P></BODY></HTML> Sat, 17 Oct 2015 22:53:00 GMT 2015-10-17T22:53:00Z How to substract time and date fields. https://community.qlik.com/t5/QlikView/How-to-substract-time-and-date-fields/m-p/1001514#M467805 <HTML><HEAD></HEAD><BODY><P>Dears..</P><P></P><P></P><P>I am creating a project dashboard and i need to substract two time fields like for example i have the field one call Time1 (12:45) and the second Time2 (13:25) if i substract Time2 - Time1 i hope to obtain the result 00:40.</P><P></P><P>And also make the same with date feilds and obtain the result in days.</P><P></P><P>Someone can help me with this?, and how to show the result in a meter grafic?</P><P></P><P>Thanks</P></BODY></HTML> Sat, 17 Oct 2015 17:30:10 GMT https://community.qlik.com/t5/QlikView/How-to-substract-time-and-date-fields/m-p/1001514#M467805 2015-10-17T17:30:10Z Re: How to substract time and date fields. https://community.qlik.com/t5/QlikView/How-to-substract-time-and-date-fields/m-p/1001515#M467806 <HTML><HEAD></HEAD><BODY><P>Use the Interval() function.</P><P></P><P>Below pasted from the QV Desktop Help :</P><P></P><P><SPAN class="Bold"><EM>interval( A-B, 'D hh:mm' )</EM></SPAN><EM> where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns:</EM></P><P><EM>&nbsp;&nbsp;&nbsp; </EM></P><TABLE cellspacing="0" class="TableStyle-LeftBold" style="margin-right: auto;"><TBODY><TR class="Body-Body1"><TD class="BodyE-Column1-Body1"><P><EM> </EM></P></TD><TD class="BodyD-Column2-Body1"><P><EM> </EM></P></TD></TR><TR class="Body-Body1"><TD class="BodyE-Column1-Body1"><P class="Bold"><EM>String </EM></P></TD><TD class="BodyD-Column2-Body1"><P align="right" class="Bold" style="text-align: right;"><EM>365 09:00 </EM></P></TD></TR><TR class="Body-Body1"><TD class="BodyE-Column1-Body1"><P class="Bold"><EM>Number </EM></P></TD><TD class="BodyD-Column2-Body1"><P align="right" class="Bold" style="text-align: right;"><EM>365.375&nbsp; </EM></P></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 17 Oct 2015 17:36:25 GMT https://community.qlik.com/t5/QlikView/How-to-substract-time-and-date-fields/m-p/1001515#M467806 Anonymous 2015-10-17T17:36:25Z Re: How to substract time and date fields. https://community.qlik.com/t5/QlikView/How-to-substract-time-and-date-fields/m-p/1001516#M467807 <HTML><HEAD></HEAD><BODY><P>Thanks works great.</P></BODY></HTML> Sat, 17 Oct 2015 22:53:00 GMT https://community.qlik.com/t5/QlikView/How-to-substract-time-and-date-fields/m-p/1001516#M467807 2015-10-17T22:53:00Z