nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

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

Accepted answers

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

All comments

Hi Anne,

That value is in seconds.

Cheers,

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

Sorry I did not see this! Thanks that helps.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud