• Community
  • Products
  • Jira
  • Questions
  • When i export a Jira project (all fields) into Excel the original estimate and remaining estimate are not as entered by the assignee.

When i export a Jira project (all fields) into Excel the original estimate and remaining estimate are not as entered by the assignee.

For example, a task in Jira is entered as 3 weeks 4 hours. When exported the original and remaining estimate fields both contain a value of 446400.

This occurs for every task on every project. I can't seem to figure out how 446,400 relates back to 3 weeks 4 hours or if this is just some sort of error with the export.

1 answer

0 vote

It's exporting a simple number of seconds for compatibility reasons (most spreadsheets won't understand strings like 3w 4d 2h). Divide it by 3,600 to get the export in hours.

I get 124 hours out of that, which implies your timetracking settings are 8 hours a day, 5 days a week because dividing by 8 gives 15.5 days.

Nic,

Thanks for the comment, but when I do the math it does not seem to work out.

If I break down the time estimate:

  • 3 weeks @ 5 days per week and 8 hours per day = 120 hrs.
  • 4 days @ 8 hrs per day = 32 hrs.
  • 2 additional hrs.

120 hrs. + 32 hrs. + 2 hrs. = 154 hrs in 3W 4d 2h (not 124 hrs).

154 hrs. = 554,400 not 446,400 as exported.

What am I missing?

I'm really sorry, I've completely muddied the waters by using a different string in my example, then doing the calculation on your real data.

You said 3 weeks, 4 hours, which is ((3 * 5 * 8) + 4) * 3600 = 446,400, and that's what you get in your spreadsheet.

If you'd used my data (3w 4d 2h), you'd get 554,400 in the spreadsheet.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

781 views 2 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you