Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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.

2 answers

@Gustavo Cardoso Ferreira 

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.

Read more about it in the Documentation >>

(Please note that Better Excel Exporter is a supported and paid app and I'm part of the team developing it.)

0 votes
Benjamin Community Leader Nov 19, 2021

Hi @Gustavo Cardoso Ferreira ,

 

Not quite sure but the hour format is by default for me when I download as an excel straight from my filter in Jira.

 

I'm using Microsoft excel for Mac version 16.

 

Thanks,

 

Ben

Hi @Benjamin 

When I export the data, the SLA column comes with the info of 5h 30m for example.

And it comes with the text format. So when I select the cells of the column Excel just counts them.

Is there a way to export the data as minutes?

Benjamin Community Leader Nov 30, 2021

Hi @Gustavo Cardoso Ferreira ,

 

It is not configurable. It is exported as it is. Any conversion will need to be done on the excel side.

 

-Ben

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Next level incident management in Jira Service Management

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 ...

1,555 views 20 12
Read article

Community Events

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

Events near you