Export to Excel in Jira: converting estimates to something useful (hours)

[Anne Jane Gray]

When I export an issue list to Excel in the "Original Estimate" column I get 28800 for 8 hours. Any way to easily format the content into something useful? Thanks

[Renjith Pillai · Accepted solution]

Add a new scripted field that converts the Original Estimate to whatever type of representation you want and use that in the Excel export

https://jamieechlin.atlassian.net/wiki/display/GRV

[Natalie Hobson]

What about adding a formula to the excel document so it converts the value from seconds to hours?

[Jeison]

Hi Anne,

That value is in seconds.

Cheers,

[Anne Jane Gray]

Sorry I did not see this! Thanks that helps.