Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Ed Maschler
Contributor
November 3, 2022

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?

1 answer

0 votes
Trudy Claspill
Community Champion
November 3, 2022

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events