When I extract the data on a excel spreadsheet the SLA column is not in a hour format, the cell is on general format. Is it possible to change that? So I can work with the data in Power BI.
Thanks in advance.
The cell type settings for date/time and other data types are indeed not configurable in the built-in Excel option. This is one of the shortcomings of Jira Cloud for Excel.
If this is important for you, one viable alternative is Better Excel Exporter that allows you to configure the date format and any other exported data type in the Excel result.
(Please note that Better Excel Exporter is a supported and paid app and I'm part of the team developing it.)
Hello Atlassian Community! We’re thrilled to announce some exciting changes to incident management in Jira Service Management Cloud, in order to give your teams extra muscle during incidents, and ...
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