Convert the date format when exporting to excel

[Avi Zilber]

Hi,

When exporting to excel, I can see the date format as a date, (09-03-1900 00:00:00), while in Jira I see it as weeks, days, hours (216w 6h 37m). I would like my excel to have the same format as Jira. How can I do it?

[Hannes Obweger - JXL for Jira]

Hi @Avi Zilber

welcome to the community!

I'm not aware of how to fix this directly in Jira, unfortunately.

However, if you're open to solutions from the Atlassian Marketplace, there's a number of apps that provide more sophisticated Excel exports.

E.g., JXL for Jira (the app that I'm working on) would export in whatever format you configured in Jira:

I configured estimates to be shown in days, but as said above, it would respect any option (days, hours, or pretty).

I assume that other apps support this, too.