You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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 SLA...so 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
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....)