Download data from table to csv. But the information is incorrect.

[KKK1]

Why did I download table from Qlik as a csv file. And the numbers aren't right.
It's like in Qlik, it's a format duration, but when opened in Excel on web, it turns into a different format.

This is a number that represents the operating time of the unit as HH:MM and the format as Duration.

This is a number that represents the operating time of the unit as HH:MM and the format as Duration.

This is formula.

My question is 1.Explain why it's like this. 2.How to edit by editing that Qlik is not Excel (I want to import completely data and Don't want to fix by excel.)

[GOKULAKANNAN]

Hi @KKK1 ,

Try converting that to text format and export the data and check if its working

[vinieme12]

There is already an Idea submitted for export to excel to retain QlikSense formatting

https://community.qlik.com/t5/Suggest-an-Idea/Keep-formatting-on-Excel-Export/idi-p/1700170/page/5#c...

for now you will have to reformat in excel again

[KKK1]

When I am editing as text and then imported into excel, the number that is seen as string requires editing in excel, which I do not want to be edited in excel again.

[KKK1]

I don't even see the solution in the attached post. 😭