When exporting to excel the original estimate, remaining estimate and time spent fields are not formatted correctly. using JIRA 4.4 excel 2010.
1 w in original estimate when exported to excel is represented as 144000.
40hrs * 60 minutes * 60 seconds = 144000
I'm not sure if that can be changed.
of course, it converts the weeks, days, hours to seconds for consistent exporting. Thank You
You can use the Better Excel Plugin to do this conversion for you. You can both use an Excel formula and Excel's cell formatting for this.
If you export time values frequently, it will save you from a lot of repetitive work.
There is a charge
It looks like you're new here. Sign in or register to get started.
