Exported filtered results using Excel CSV. Time spent value is converted to invalid format.

[Shailaja_Tadla]

I tried exporting my filtered results using Excel (CSV) format. In the exported file, Time spent value is converted to invalid format. Any suggestion how to get the time stamp as is in exported file?

[Trudy Claspill]

The value is not invalid. It is the time spent expressed in Seconds.

What you see in Jira is an automated conversion in the UI of the actual value, which is stored in the database as Seconds. The export will export the actual value.