Explore: Ticket resolution time without time between solved and closed

I am trying to create a report that shows time between a new ticket created to resolution (solved) for a specific group of people and categories.

I want to calculate this time up to ticket status Solved and exclude time between Solved and Closed as we have a 30-day window between Solved and Closed, causing the numbers to be highly inflated.

Is there a way to do this?