Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Time( 6.64721 / 24, 'hh:mm')
May be this
=Time(6.64721/24)
Thanks for a quick answer
Ok, it's fine
And how would I convert if I have to more than 24 hours? 30,56 hours