topic Converting hours to min in QlikView https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157374#M32881 <HTML><HEAD></HEAD><BODY><P>Hi, this helps too</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />interval('12:50','m')<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>returns 770 = 12*60 + 50</P><P>Rgds</P></BODY></HTML> Thu, 06 Jan 2011 18:55:07 GMT hector 2011-01-06T18:55:07Z Converting hours to min https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157370#M32877 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Is it possible to show convert hours into minutes by adding the minutes to it. Like if it is 12:50:00. I want to convert the 12hrs to minutes and add with the 50 minutes.</P></BODY></HTML> Thu, 06 Jan 2011 13:10:50 GMT https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157370#M32877 2011-01-06T13:10:50Z Converting hours to min https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157371#M32878 <HTML><HEAD></HEAD><BODY><P></P><P>use this</P><P></P><P>=</P><BR /><BR /> <B>SubField</B>('12:50:00',':',1) *60 + <B>SubField</B>('12:50:00',':',2) <P></P><P><B>SubField</B>('12:50:00',':',1) *60 + <B>SubField</B>('12:50:00',':',2)</P><BR /><BR /> <P></P><BR /><BR /> <P></P></BODY></HTML> Thu, 06 Jan 2011 13:17:25 GMT https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157371#M32878 2011-01-06T13:17:25Z Converting hours to min https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157372#M32879 <HTML><HEAD></HEAD><BODY><P>Hello again,</P><P>see the attached example.</P><P>I played arround a little bit with days, hours, minutes and so on.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 06 Jan 2011 13:20:30 GMT https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157372#M32879 2011-01-06T13:20:30Z AW:Converting hours to min https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157373#M32880 <HTML><HEAD></HEAD><BODY><P>You want this?</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">= hour('12:50:00') * 60 + minute('12:50:00')</PRE></BLOCKQUOTE><BR /><BR /> <P></P></BODY></HTML> Thu, 06 Jan 2011 17:39:10 GMT https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157373#M32880 rbecher 2011-01-06T17:39:10Z Converting hours to min https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157374#M32881 <HTML><HEAD></HEAD><BODY><P>Hi, this helps too</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />interval('12:50','m')<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>returns 770 = 12*60 + 50</P><P>Rgds</P></BODY></HTML> Thu, 06 Jan 2011 18:55:07 GMT https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157374#M32881 hector 2011-01-06T18:55:07Z Converting hours to min https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157375#M32882 <HTML><HEAD></HEAD><BODY><P>Yet another way:</P><P style="padding-left:30px;">interval#('12:50','hh:mm')*24*60</P></BODY></HTML> Fri, 07 Jan 2011 02:51:53 GMT https://community.qlik.com/t5/QlikView/Converting-hours-to-min/m-p/157375#M32882 johnw 2011-01-07T02:51:53Z