https://community.qlik.com/t5/QlikView/Formatting-time/m-p/1729519#M722342 <P>Hi All,</P><P>I have the number 350.5 in a field called TIME.&nbsp; It represents 350 hours and 30 minutes.&nbsp; How can I display this field so it shows as hh:mm, so it would show as 350:30.</P><P>&nbsp;</P><P>Any ideas?&nbsp; Thank you</P> Wed, 25 Nov 2020 16:16:04 GMT drohm002 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Formatting-time/m-p/1729519#M722342 <P>Hi All,</P><P>I have the number 350.5 in a field called TIME.&nbsp; It represents 350 hours and 30 minutes.&nbsp; How can I display this field so it shows as hh:mm, so it would show as 350:30.</P><P>&nbsp;</P><P>Any ideas?&nbsp; Thank you</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Formatting-time/m-p/1729519#M722342 drohm002 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Formatting-time/m-p/1729548#M722343 <P>try below</P><P>=interval(<STRONG>TIME</STRONG>/24,'hh:mm')</P> Tue, 21 Jul 2020 15:05:46 GMT https://community.qlik.com/t5/QlikView/Formatting-time/m-p/1729548#M722343 Kushal_Chawda 2020-07-21T15:05:46Z