Convert a decimal hour to format hh:mm

[magnusrydberg]

I have a field containing a decimal time in hours. For example 6.64721 means 6 hours and 39 minutes

How do I do this conversion the best way in QlikSense: 6,64721 ->  6:39

[Gysbert_Wassenaar · Accepted solution]

Time( 6.64721 / 24, 'hh:mm')

[sunny_talwar]

May be this

=Time(6.64721/24)

[magnusrydberg]

Thanks for a quick answer

[voxjungle]

Can i use this formula in a Pivot table ?.

[marioerro]

Ok, it's fine

And how would I convert if I have to more than 24 hours? 30,56 hours