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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.