Exporting converts Original estimate from Hours:Min in Jira to seconds in Excel. How not to?

Ed Maschler_y5a6dk

If I run a report in Jira cloud, I can export things like the Original Estimate.  
The original estimate in Jira shows as a hour:minutes.  But if I export it, it becomes # of seconds.

I would like to keep it from doing that switch and keeping it in hours and minures in the exported Excel file.  How to?

Trudy P Claspill

Hello @Ed Maschler 

The data is stored in Jira in seconds. With the built in export to Excel you cannot change how the value is exported.

In Excel itself you can convert it.

Or, from this post, you could consider the third party app Better Excel Exporter.