https://community.qlik.com/t5/QlikView/time-format/m-p/1949161#M1219670 <P>Hello everyone:</P> <P>I don't know how to solve the following time format, which is the following.</P> <P>1.50 is the value of the field, but it should be read as 1:30 since 50 is the percentage not the minutes.</P> <P>Any function to solve this?</P> Tue, 28 Jun 2022 14:35:41 GMT tincholiver 2022-06-28T14:35:41Z https://community.qlik.com/t5/QlikView/time-format/m-p/1949161#M1219670 <P>Hello everyone:</P> <P>I don't know how to solve the following time format, which is the following.</P> <P>1.50 is the value of the field, but it should be read as 1:30 since 50 is the percentage not the minutes.</P> <P>Any function to solve this?</P> Tue, 28 Jun 2022 14:35:41 GMT https://community.qlik.com/t5/QlikView/time-format/m-p/1949161#M1219670 tincholiver 2022-06-28T14:35:41Z https://community.qlik.com/t5/QlikView/time-format/m-p/1949196#M1219671 <P>If you simply divide by 24 and display as duration (QS) or Interval (QV), this should be correct as-is.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Or_0-1656429575543.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82844i210C6A4445873A8A/image-size/medium?v=v2&amp;px=400" role="button" title="Or_0-1656429575543.png" alt="Or_0-1656429575543.png" /></span></P> <P>&nbsp;</P> Tue, 28 Jun 2022 15:20:08 GMT https://community.qlik.com/t5/QlikView/time-format/m-p/1949196#M1219671 Or 2022-06-28T15:20:08Z https://community.qlik.com/t5/QlikView/time-format/m-p/1949206#M1219672 <P>I work perfectly.<BR />In the script add :</P> <P>interval(time/24) and that's it, I'm converted!</P> <P>Thanks a lot</P> Tue, 28 Jun 2022 15:33:33 GMT https://community.qlik.com/t5/QlikView/time-format/m-p/1949206#M1219672 tincholiver 2022-06-28T15:33:33Z