topic Re: waiting time in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/waiting-time/m-p/748749#M1263 <HTML><HEAD></HEAD><BODY><P>Hi Mario, you can add a format to the interval, ie:</P><P>interval(timefield, 'hh:mm:ss')</P><P></P><P>Also, in number tab of graphics you can change the format.</P></BODY></HTML> Fri, 14 Nov 2014 13:28:10 GMT rubenmarin 2014-11-14T13:28:10Z waiting time https://community.qlik.com/t5/Qlik-Learning-Discussions/waiting-time/m-p/748747#M1261 <HTML><HEAD></HEAD><BODY><P>Dear all ,</P><P></P><P>i found it the waiting time using the<SPAN style="text-decoration: underline;"> interval Function</SPAN> but as you can See 'AM' shows in the waiting time how can i erase it ?</P><P></P><P></P><P>Starting Time&nbsp;&nbsp; Ending Time&nbsp;&nbsp; Waiting Time</P><P>07:42:35:90&nbsp;&nbsp;&nbsp;&nbsp; 07:43:57:89&nbsp;&nbsp;&nbsp; 0:01:22 AM</P><P></P><P> Waiting Time&nbsp; </P></BODY></HTML> Fri, 14 Nov 2014 13:12:41 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/waiting-time/m-p/748747#M1261 mario-sarkis 2014-11-14T13:12:41Z Re: waiting time https://community.qlik.com/t5/Qlik-Learning-Discussions/waiting-time/m-p/748748#M1262 <HTML><HEAD></HEAD><BODY><P>specify a time format as second parameter in the interval function: interval([Ending Time]-[Starting Time],'h:mm:ss')</P></BODY></HTML> Fri, 14 Nov 2014 13:27:38 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/waiting-time/m-p/748748#M1262 Gysbert_Wassenaar 2014-11-14T13:27:38Z Re: waiting time https://community.qlik.com/t5/Qlik-Learning-Discussions/waiting-time/m-p/748749#M1263 <HTML><HEAD></HEAD><BODY><P>Hi Mario, you can add a format to the interval, ie:</P><P>interval(timefield, 'hh:mm:ss')</P><P></P><P>Also, in number tab of graphics you can change the format.</P></BODY></HTML> Fri, 14 Nov 2014 13:28:10 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/waiting-time/m-p/748749#M1263 rubenmarin 2014-11-14T13:28:10Z