topic Re: Convert decimal minutes into HH:mm in QlikView https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202269#M60041 <HTML><HEAD></HEAD><BODY><P>Thank you Miguel Angel!</P></BODY></HTML> Tue, 26 Nov 2013 09:44:22 GMT edisa 2013-11-26T09:44:22Z Convert decimal minutes into HH:mm https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202266#M60038 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have a db were time format is as follows:</P><P>60 is 1:00 AM</P><P>120 is 2:00 AM</P><P>130 is 2:10 AM etc.</P><P>How can I display them in HH:mm in the same column?</P><P>Thanks in advance!</P></BODY></HTML> Thu, 25 Nov 2010 15:56:36 GMT https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202266#M60038 2010-11-25T15:56:36Z Convert decimal minutes into HH:mm https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202267#M60039 <HTML><HEAD></HEAD><BODY><P>Have a look at this thread - it may point you in the right direction.</P><P><A href="http://community.qlik.com/forums/t/34775.aspx">http://community.qlik.com/forums/t/34775.aspx</A></P></BODY></HTML> Thu, 25 Nov 2010 17:56:48 GMT https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202267#M60039 2010-11-25T17:56:48Z Convert decimal minutes into HH:mm https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202268#M60040 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Is this what you need?</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=interval(interval#(150, 'm'), 'hh:mm')</PRE></BLOCKQUOTE><BR /><BR /> <P>Regards</P></BODY></HTML> Thu, 25 Nov 2010 18:08:00 GMT https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202268#M60040 Miguel_Angel_Baeyens 2010-11-25T18:08:00Z Re: Convert decimal minutes into HH:mm https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202269#M60041 <HTML><HEAD></HEAD><BODY><P>Thank you Miguel Angel!</P></BODY></HTML> Tue, 26 Nov 2013 09:44:22 GMT https://community.qlik.com/t5/QlikView/Convert-decimal-minutes-into-HH-mm/m-p/202269#M60041 edisa 2013-11-26T09:44:22Z