Export to excel formatting issues

Dermot Mee July 25, 2012

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.

2 answers

1 accepted

0 votes
Answer accepted
Martin Aparicio July 25, 2012

40hrs * 60 minutes * 60 seconds = 144000

I'm not sure if that can be changed.

Dermot Mee July 25, 2012

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

0 votes
Midori
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 30, 2015

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 September 15, 2020

There is a charge

Suggest an answer

Log in or Sign up to answer