topic Re: formating in QlikView https://community.qlik.com/t5/QlikView/formating/m-p/1022031#M345643 <HTML><HEAD></HEAD><BODY><P>Try like this:</P><P></P><P><STRONG>=Interval(250.25/(60*24), 'hh:mm')</STRONG></P><P></P><P>UPDATE: For your scenario -&gt; <STRONG>=Interval(Only(FieldTime)/(60*24), 'hh:mm') <BR /></STRONG></P></BODY></HTML> Mon, 07 Mar 2016 18:16:40 GMT sunny_talwar 2016-03-07T18:16:40Z formating https://community.qlik.com/t5/QlikView/formating/m-p/1022030#M345642 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a text object in my model which contains the formula '=only(FieldTime)'. It returns the value 250,25.</P><P>I'd like to set the time format for this formula so that I can get a result 4:10 (4 hours and 10 minutes).</P><P></P><P>How can I do it?</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Mon, 07 Mar 2016 18:14:01 GMT https://community.qlik.com/t5/QlikView/formating/m-p/1022030#M345642 Anonymous 2016-03-07T18:14:01Z Re: formating https://community.qlik.com/t5/QlikView/formating/m-p/1022031#M345643 <HTML><HEAD></HEAD><BODY><P>Try like this:</P><P></P><P><STRONG>=Interval(250.25/(60*24), 'hh:mm')</STRONG></P><P></P><P>UPDATE: For your scenario -&gt; <STRONG>=Interval(Only(FieldTime)/(60*24), 'hh:mm') <BR /></STRONG></P></BODY></HTML> Mon, 07 Mar 2016 18:16:40 GMT https://community.qlik.com/t5/QlikView/formating/m-p/1022031#M345643 sunny_talwar 2016-03-07T18:16:40Z Re: formating https://community.qlik.com/t5/QlikView/formating/m-p/1022032#M345644 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Mon, 07 Mar 2016 18:24:07 GMT https://community.qlik.com/t5/QlikView/formating/m-p/1022032#M345644 Anonymous 2016-03-07T18:24:07Z