The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I get wrong number format in excel export

Vicenco Tarabene
Contributor
March 3, 2023

When I try to export data that would contain numbers from original estimate, time spent and story point fields I get some strange numbers instead of the ones that should be there.

Is this a bug to report or it has something to do with some setup? 

UPDATE

By looking at numbers I have figured out at least that what they all have in common is a number "3600" for some reason. So if I divide the number I get with 3600 I will get the right times that I need. Not a solution but still an easy way to get around until we figure out why this happens 

JIRA.png

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
Aron Gombas _Midori_
Community Champion
March 3, 2023

Those values are seconds, not hours! Therefore "1 hour" is exported as "3600" (seconds). It is known behavior, although criticized by many.

You can use the Better Excel Exporter app as an alternative, which exports these values as hours and give similar intuitive formatting for other fields, too:

jira-issues-selected-fields-with-worklogs.png

(Discl. it is a paid and supported app developed by our team.)

Vicenco Tarabene
Contributor
March 5, 2023

Thanks

DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events