topic Calculating time diff in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216045#M69445 <HTML><HEAD></HEAD><BODY><P>Use the Interval() function</P><P></P><P>Interval(arrival_loop1 - departure_loop1, 'hh:mm:ss')</P></BODY></HTML> Thu, 14 Apr 2011 13:46:45 GMT 2011-04-14T13:46:45Z Calculating time diff in Qlikview https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216044#M69444 <HTML><HEAD></HEAD><BODY><P>Hi, this q has not been answered in this forum but many people must struggle with this:</P><P></P><P>Q: how to calculate time diff in script?</P><P>Ex Calc time between 2 loops. This is how I do it. Any comments and risk with this? I notcied that neg values doesnt go well, so u have to check for that or trust the data.</P><P></P><P></P><P></P><P></P>Time(Time(departure_loop1) - (Time(arrival_loop1))) as Diff_Dep1_Arr1 <P>I would appreciate a "TimeDiff" function!</P><P>Regards</P><P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 14 Apr 2011 13:40:51 GMT https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216044#M69444 svante 2011-04-14T13:40:51Z Calculating time diff in Qlikview https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216045#M69445 <HTML><HEAD></HEAD><BODY><P>Use the Interval() function</P><P></P><P>Interval(arrival_loop1 - departure_loop1, 'hh:mm:ss')</P></BODY></HTML> Thu, 14 Apr 2011 13:46:45 GMT https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216045#M69445 2011-04-14T13:46:45Z Calculating time diff in Qlikview https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216046#M69446 <HTML><HEAD></HEAD><BODY><P>Big THX!! More elegant solution.</P><P><IMG alt="Yes" src="http://community.qlik.com/emoticons/emotion-21.gif" /></P></BODY></HTML> Thu, 14 Apr 2011 14:52:51 GMT https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216046#M69446 svante 2011-04-14T14:52:51Z Re: Calculating time diff in Qlikview https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216047#M69447 <HTML><HEAD></HEAD><BODY><P>This solution will crush when departure is exactly at midnight or after it as <SPAN class="j-post-author"><STRONG><A href="https://community.qlik.com/people/Svante">Svante</A></STRONG> used time not timestamp.</SPAN></P></BODY></HTML> Sat, 13 Feb 2016 16:30:45 GMT https://community.qlik.com/t5/QlikView/Calculating-time-diff-in-Qlikview/m-p/216047#M69447 hubertdudek 2016-02-13T16:30:45Z