topic Re: Convert time into minutes in QlikView https://community.qlik.com/t5/QlikView/Convert-time-into-minutes/m-p/440884#M164340 <HTML><HEAD></HEAD><BODY><P>You may try Interval function. </P><P>For example, interval(Time#('01:00:00','hh:mm:ss'),'mm') gives 60</P></BODY></HTML> Mon, 17 Dec 2012 00:25:39 GMT nagaiank 2012-12-17T00:25:39Z Convert time into minutes https://community.qlik.com/t5/QlikView/Convert-time-into-minutes/m-p/440883#M164339 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a field name arrival_time in the format hh:mm:ss. </P><P>I am looking to convert into minutes. </P><P></P><P>Regards,</P><P>Kv.</P></BODY></HTML> Sun, 16 Dec 2012 23:35:43 GMT https://community.qlik.com/t5/QlikView/Convert-time-into-minutes/m-p/440883#M164339 2012-12-16T23:35:43Z Re: Convert time into minutes https://community.qlik.com/t5/QlikView/Convert-time-into-minutes/m-p/440884#M164340 <HTML><HEAD></HEAD><BODY><P>You may try Interval function. </P><P>For example, interval(Time#('01:00:00','hh:mm:ss'),'mm') gives 60</P></BODY></HTML> Mon, 17 Dec 2012 00:25:39 GMT https://community.qlik.com/t5/QlikView/Convert-time-into-minutes/m-p/440884#M164340 nagaiank 2012-12-17T00:25:39Z Re: Convert time into minutes https://community.qlik.com/t5/QlikView/Convert-time-into-minutes/m-p/440885#M164341 <HTML><HEAD></HEAD><BODY><P>hay use this function in might be helps to you...</P><P><SPAN style="color: #0000ff;"><SPAN style="color: #000000;">=</SPAN> interval(Time#(<SPAN style="color: #800000;">arrival_time</SPAN>,<SPAN style="color: #000000;">'hh:mm:ss'),'mm') &amp;&nbsp; ' minutes ' </SPAN><BR /></SPAN></P><P>regards </P><P>Mohit</P></BODY></HTML> Mon, 17 Dec 2012 11:12:56 GMT https://community.qlik.com/t5/QlikView/Convert-time-into-minutes/m-p/440885#M164341 er_mohit 2012-12-17T11:12:56Z