https://community.qlik.com/t5/App-Development/Time-Format-User-Readable/m-p/1650450#M48530 <P>Perhaps doing lengthy way?</P><P><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'DD') &amp; ' Days, ' &amp; </STRONG><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'hh') &amp; ' Hours, ' &amp;&nbsp;&nbsp;</STRONG><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'mm') &amp; ' Minutes, ' &amp;&nbsp;</STRONG><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'ss') &amp; ' Seconds'</STRONG></P> Sun, 24 Nov 2019 13:31:50 GMT Anil_Babu_Samineni 2019-11-24T13:31:50Z https://community.qlik.com/t5/App-Development/Time-Format-User-Readable/m-p/1650418#M48528 <P>I have this expression&nbsp;</P><DIV class="BubbleStyle_MessageContainer"><DIV>INTERVAL(FABS(AVG(Time_Diff))ddhhmm) in bar graph expression is used and i want the following format for expression which user can easily read&nbsp; &nbsp;2 Days ,07 Hours ,30 Minute ,2 Sec&nbsp;&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>Thanks&nbsp;</DIV></DIV> Sat, 16 Nov 2024 04:02:18 GMT https://community.qlik.com/t5/App-Development/Time-Format-User-Readable/m-p/1650418#M48528 Zafar 2024-11-16T04:02:18Z https://community.qlik.com/t5/App-Development/Time-Format-User-Readable/m-p/1650450#M48530 <P>Perhaps doing lengthy way?</P><P><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'DD') &amp; ' Days, ' &amp; </STRONG><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'hh') &amp; ' Hours, ' &amp;&nbsp;&nbsp;</STRONG><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'mm') &amp; ' Minutes, ' &amp;&nbsp;</STRONG><STRONG>INTERVAL(FABS(AVG(Time_Diff)), 'ss') &amp; ' Seconds'</STRONG></P> Sun, 24 Nov 2019 13:31:50 GMT https://community.qlik.com/t5/App-Development/Time-Format-User-Readable/m-p/1650450#M48530 Anil_Babu_Samineni 2019-11-24T13:31:50Z