Export to excel formatting issues

[Dermot Mee]

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.

[Martin Aparicio · Accepted solution]

40hrs * 60 minutes * 60 seconds = 144000

I'm not sure if that can be changed.

[Dermot Mee]

of course, it converts the weeks, days, hours to seconds for consistent exporting. Thank You

[Midori]

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.

[carla lefley]

There is a charge