I'm trying to track how long a ticket stays assigned to a specific value through the life-cycle of the ticket.

For example: -

20/05 - Ticket01 Created - Technician Unassigned

21/05 - Ticked01 Under Investigation - Technician Assigned to A

22/05 - Ticked01 Under Investigation - Technician Assigned to B

22/05 - Ticked01 Closed

I'm trying to track the time (preferably in minutes) between Ticket01 moving from an Unassigned State to an Assigned state and then additional how long A had it before it was reassigned to B and then subsequently closed.

If multiple actions happen on the same day 'Last Updated' becomes really inaccurate.

Does anybody have a solution for something like this?