Find all tickets where the time between two statuses exceeds a certain value

Question

Our bug tickets start out in the Status "New". At some point they are confirmed and move to the Status "Confirmed". Eventually the bug fix is completed and the ticket moved to the status "Done". 
I want to find all tickets that have spent more than a certain amount of days between the status "Confirmed" and "Done". The clock should start as soon as a ticket is moved to "Confirmed".

Is this possible to do with JQL?

Derek Fields _RightStar_ · Accepted Answer

This requires a plugin. There are several in the marketplace. Search on "Time in Status"

Gökçe Gürsel {Appfire} · Accepted Answer

Hi @Roland Weilbacher ,

You can use Enhancer Plugin for Jira for this requirement.

It has custom fields called Time between and Time in status custon fields that measures the time spent between two statuses/ events. You can also see drill down information based on assignee and you can search issues against Time between field in the issue navigator.

Let me know if you have any questions.

Cheers,

Gokce