Convert decimal minutes into HH:mm

[#1]

Hello All,

I have a db were time format is as follows:

60 is 1:00 AM

120 is 2:00 AM

130 is 2:10 AM etc.

How can I display them in HH:mm in the same column?

Thanks in advance!

[#2]

Have a look at this thread - it may point you in the right direction.

http://community.qlik.com/forums/t/34775.aspx

[Miguel_Angel_Baeyens]

Hi,

Is this what you need?

=interval(interval#(150, 'm'), 'hh:mm')

Regards

[edisa]

Thank you Miguel Angel!