topic Re: Difference between two date with time. in QlikView https://community.qlik.com/t5/QlikView/Difference-between-two-date-with-time/m-p/818594#M288614 <HTML><HEAD></HEAD><BODY><P>Use Interval().</P></BODY></HTML> Tue, 17 Feb 2015 07:40:09 GMT senpradip007 2015-02-17T07:40:09Z Difference between two date with time. https://community.qlik.com/t5/QlikView/Difference-between-two-date-with-time/m-p/818593#M288613 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Need Help.</P><P></P><P>I got one mail on 23-1-15 11:46 and read or open that mail on 14-2-15 15:40 and forwarded on 20-2-15 so I have three date as above and&nbsp; want to find out the date difference on this with time and exclude Saturday , Sunday and holiday like 26-01-2015.<BR />and i want to calculate time also my office time is 9:00 to 18:00.</P><P></P><P></P><P></P><P>Thanks<BR />Prashant</P></BODY></HTML> Tue, 17 Feb 2015 07:34:28 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-date-with-time/m-p/818593#M288613 prma7799 2015-02-17T07:34:28Z Re: Difference between two date with time. https://community.qlik.com/t5/QlikView/Difference-between-two-date-with-time/m-p/818594#M288614 <HTML><HEAD></HEAD><BODY><P>Use Interval().</P></BODY></HTML> Tue, 17 Feb 2015 07:40:09 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-date-with-time/m-p/818594#M288614 senpradip007 2015-02-17T07:40:09Z Re: Difference between two date with time. https://community.qlik.com/t5/QlikView/Difference-between-two-date-with-time/m-p/818595#M288615 <HTML><HEAD></HEAD><BODY><P>Can you explain more?</P></BODY></HTML> Tue, 17 Feb 2015 08:53:11 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-date-with-time/m-p/818595#M288615 prma7799 2015-02-17T08:53:11Z