topic Re: HH:MM:SS format - Exporting To Excel in App Development https://community.qlik.com/t5/App-Development/HH-MM-SS-format-Exporting-To-Excel/m-p/1733480#M56001 <P>neve encountered this exact scenario but why dont you try converting that column into a text e.g. ' '&amp; yourcolumn</P> Wed, 05 Aug 2020 14:08:10 GMT dplr-rn 2020-08-05T14:08:10Z HH:MM:SS format - Exporting To Excel https://community.qlik.com/t5/App-Development/HH-MM-SS-format-Exporting-To-Excel/m-p/1733461#M55990 <P>I have a value in QlikSense displayed in HH:MM:SS format, for example 26:12:12, representing 26 hours, 12 minutes, 12 seconds.</P><P>This displays fine in a chart but when I export to excel, if the value is over 24 hours, the value displays as a date with an associated time element. The time element is the HH:MM:SS of the incomplete day e.g. 2:12:12 in the above scenario.</P><P>We can ask the user to change the excel format but that is not great. we want to continue to show hh:MM:ss in Qlik.</P><P>Any suggestions of forcing excel to show the right format?&nbsp; &nbsp;</P> Wed, 05 Aug 2020 13:39:16 GMT https://community.qlik.com/t5/App-Development/HH-MM-SS-format-Exporting-To-Excel/m-p/1733461#M55990 SimonHawes 2020-08-05T13:39:16Z Re: HH:MM:SS format - Exporting To Excel https://community.qlik.com/t5/App-Development/HH-MM-SS-format-Exporting-To-Excel/m-p/1733480#M56001 <P>neve encountered this exact scenario but why dont you try converting that column into a text e.g. ' '&amp; yourcolumn</P> Wed, 05 Aug 2020 14:08:10 GMT https://community.qlik.com/t5/App-Development/HH-MM-SS-format-Exporting-To-Excel/m-p/1733480#M56001 dplr-rn 2020-08-05T14:08:10Z