Ticket Status Durations - Reporting

Hi

We currently use ticket status to track the progress of a ticket as it moves through to resolution. We have a number of different status over and above the standard New, in progress, resolved including Pending Customer, On Hold, Pending Supplier and a few others. Is there a report or a way to report on the duration spent in each status over the life of a ticket. Ideally we want to be able to report on e.g. all Resolved/Closed Tickets for a specified period and see for each ticket - the time they spent in each status

Any help most appreciated - have looked at trying to create some new key figures for this but cannot get to work

Thanks

Annabelle