Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

magnusrydberg
New Contributor II

Convert a decimal hour to format hh:mm

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

1 Solution

Accepted Solutions

Re: Convert a decimal hour to format hh:mm

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


talk is cheap, supply exceeds demand
3 Replies

Re: Convert a decimal hour to format hh:mm

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


talk is cheap, supply exceeds demand
MVP
MVP

Re: Convert a decimal hour to format hh:mm

May be this

=Time(6.64721/24)

magnusrydberg
New Contributor II

Re: Convert a decimal hour to format hh:mm

Thanks for a quick answer