Download data from table to csv. But the information is incorrect. I want to keep formatting on Excel Export

[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 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.)

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.

[vinieme12]

you would need an extension to retain formats

https://github.com/iviasensio/SmartExport

https://logiexport.logsys.co.il/

[simospa]

You could try to format the number in the load script (or in table), using interval function:

so when you want to export the set you can keep the original formatting.

Does it work for you?

S.

[KKK1]

It doesn't work sir😥

I was tried to format the number in table 

[simospa]

Did you try to format it in the load script?

S.

[KKK1]

Yes, I did!