Convert minutes to duration

[valnod_90]

Hi guys 

I need a little help from you
I have a column in my table that displays minutes and i need to convert them into duration, for example 90 minutes should be turned into 1 hour and 30 minutes (1:30).

How can i do it?

Thank you

[vikramhssa]

Try this 

Floor(90/60)&':'&mod(90,60)

[YoussefBelloum]

Hi,

Suppose your field is called minutes

you can try this:

=Time(Time#(minutes,'mm'),'hh:mm')

[qlikpritamdeb · Accepted solution]

Hi,

You can use below expression:

=interval(90/1440,'hh:mm')

Thanks

[johanlindell]

All Qlik formatting of time and dates is based on 24 hour days. Divide 90 with 60 * 24. If you want a "duration" use the Interval function to display it in hours and minutes. The interval will show more than 24 hours if needed.
Interval (90/1440, 'hh:mm')