Reporting on "time in status"?

RT Users
1

Is it possible to query on how long some tickets have been a particular status?

E.g. “How long does it take on average for tickets opened in July to change from New to Open?”