topic Re: Convert a decimal hour to format hh:mm in App Development https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371463#M30952 <HTML><HEAD></HEAD><BODY><P>Time( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">6.64721</SPAN> / 24, 'hh:mm')</P></BODY></HTML> Wed, 14 Jun 2017 16:18:39 GMT Gysbert_Wassenaar 2017-06-14T16:18:39Z Convert a decimal hour to format hh:mm https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371462#M30951 <HTML><HEAD></HEAD><BODY><P>I have a field containing a decimal time in hours. For example 6.64721 means 6 hours and 39 minutes</P><P>How do I do this conversion the best way in QlikSense: 6,64721 -&gt;&nbsp; 6:39</P></BODY></HTML> Wed, 14 Jun 2017 16:14:15 GMT https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371462#M30951 magnusrydberg 2017-06-14T16:14:15Z Re: Convert a decimal hour to format hh:mm https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371463#M30952 <HTML><HEAD></HEAD><BODY><P>Time( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">6.64721</SPAN> / 24, 'hh:mm')</P></BODY></HTML> Wed, 14 Jun 2017 16:18:39 GMT https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371463#M30952 Gysbert_Wassenaar 2017-06-14T16:18:39Z Re: Convert a decimal hour to format hh:mm https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371464#M30953 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>=Time(6.64721/24)</STRONG></P></BODY></HTML> Wed, 14 Jun 2017 16:22:21 GMT https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371464#M30953 sunny_talwar 2017-06-14T16:22:21Z Re: Convert a decimal hour to format hh:mm https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371465#M30954 <HTML><HEAD></HEAD><BODY><P>Thanks for a quick answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 14 Jun 2017 16:25:18 GMT https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1371465#M30954 magnusrydberg 2017-06-14T16:25:18Z Re: Convert a decimal hour to format hh:mm https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1608435#M45156 Can i use this formula in a Pivot table ?. Thu, 01 Aug 2019 10:45:02 GMT https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1608435#M45156 voxjungle 2019-08-01T10:45:02Z Re: Convert a decimal hour to format hh:mm https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1637700#M47539 <P>Ok, it's fine</P><P>And how would I convert if I have to more than 24 hours? 30,56 hours</P> Mon, 21 Oct 2019 10:16:56 GMT https://community.qlik.com/t5/App-Development/Convert-a-decimal-hour-to-format-hh-mm/m-p/1637700#M47539 marioerro 2019-10-21T10:16:56Z