topic Re: Duration question in QlikView https://community.qlik.com/t5/QlikView/Duration-question/m-p/287925#M107120 <HTML><HEAD></HEAD><BODY><P> Found in other forum:</P><PRE class="notranslate">=Interval(Time(Time#('Start', 'hh:mmtt')) - Time(Time#('End', 'hh:mmtt')), 'hh:mm')</PRE><P></P><P></P><P>Thank Mugel</P><P></P><P>Krishna</P></BODY></HTML> Tue, 01 Nov 2011 14:52:18 GMT 2011-11-01T14:52:18Z Duration question https://community.qlik.com/t5/QlikView/Duration-question/m-p/287923#M107118 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P></P><P></P><P>I have two date values in the fields 'start' and 'end':</P><P></P><P></P><P>2011-06-27 02:22:00 PM</P><P>and</P><P>2011-06-27 04:27:30 PM</P><P></P><P></P><P>I want to know how i can calculate the time passed 'start' and 'end' within my LOAD script.</P><P></P><P></P><P>Any ideas ?</P></BODY></HTML> Tue, 01 Nov 2011 13:42:13 GMT https://community.qlik.com/t5/QlikView/Duration-question/m-p/287923#M107118 2011-11-01T13:42:13Z Re: Duration question https://community.qlik.com/t5/QlikView/Duration-question/m-p/287924#M107119 <HTML><HEAD></HEAD><BODY><P>The following expression will give duration in seconds:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>round((<SPAN style="color: #c23a66;">end</SPAN>-<SPAN style="color: #c23a66;">start</SPAN>)*3600*24,1)</P></PRE><P></P><P>Kiran.</P></BODY></HTML> Tue, 01 Nov 2011 14:08:44 GMT https://community.qlik.com/t5/QlikView/Duration-question/m-p/287924#M107119 2011-11-01T14:08:44Z Re: Duration question https://community.qlik.com/t5/QlikView/Duration-question/m-p/287925#M107120 <HTML><HEAD></HEAD><BODY><P> Found in other forum:</P><PRE class="notranslate">=Interval(Time(Time#('Start', 'hh:mmtt')) - Time(Time#('End', 'hh:mmtt')), 'hh:mm')</PRE><P></P><P></P><P>Thank Mugel</P><P></P><P>Krishna</P></BODY></HTML> Tue, 01 Nov 2011 14:52:18 GMT https://community.qlik.com/t5/QlikView/Duration-question/m-p/287925#M107120 2011-11-01T14:52:18Z