Hi, I am trying to export issues to Excel.
I use these options as seen on the picture :
Option 1: generates fields that aren't accurate with weird values.
Option 2: Looks good but I would like the date to be without hours : "dd/mm/yyyy" and the value of the Time spent is in seconds (1800) and should be in minutes (30m).
The time in Excel is displayed in seconds, but in jira it is displayed in minutes (30m) as it should be.
Any way to configure that? Thank you for any informations :)
Hi @Szymon Ptak
I believe you are seeing the differences between the Jira source data (e.g. 1800 seconds) and the presentation in the user interface/experience views (e.g. 30 minutes).
Once you have the source data in the spreadsheet, have you tried to manipulate it to your format / reporting needs? Such as converting the seconds to minutes or truncating the hours from the date/time values.
Do you mean the Atlassian built plug-ins for Excel and Google Sheets?
If so, there are several alternatives which do not require purchasing other marketplace add-ons:
In general, that is not possible. You may change your localization settings for date/time but not the export formats for specific fields.
You note not wanting to use Excel formulas when doing the reports. If you use the free Atlassian plug-ins for Excel or Google Sheets, you can pull the data into one tab and process it on another, reducing the needs to modify the spreadsheet forumulas with each download.
Please look here for information about the Excel version:
If that solution will not work, please investigate the marketplace for reporting add-ons for purchase.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events