I have a value in QlikSense displayed in HH:MM:SS format, for example 26:12:12, representing 26 hours, 12 minutes, 12 seconds.
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.
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.
Any suggestions of forcing excel to show the right format?
