Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How long to "resolve" and excel

Hello Team....I am exporting a monthly filter to excel to see how many tickets per month and how long it took to resolve them. Unfortunately Jira sees the "time to resolve" as how much time was left the if it took 3 hours to resolve....the resolve time would be 37 hour from an SLA of 40 hours. In addition the format does not easily convert to hours very well. Does any have a work around to get just the hours it took to resolve the issue. Much thanks in advance  

Screenshot 2022-06-23 140251.jpg

1 answer

You can try to include "Created date" and "Resolution date" columns in your filter.

Then you can use DATEDIF function in excel which allows to control the way you want to display that difference (minutes, hours, days etc....)

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

204 views 0 6
Join discussion

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