Time Difference Between Event Dates

I've been tasked with a challenging request which I believe a macro will be required (I'd love to do it with formula, but I'm not sure it's possible). Of course, my experience with macros is recording and modifying those created by others...sigh.

Here is a scenario:
I have an item with various history events. The item's unique ID is its Date/Time stamp. By using the Event Begin Date/Time, I need to find the difference in time when queues and statuses change. I have various combinations, but for this example, I'll focus on Admin. When the item is in the queue ADMIN (regardless of status, so the first event of queue Admin), I need to calculate the span of time between the Event Begin Date/Time for this event and when the item's status changes to a new status. So, in the table below, I need to identify the first event in which the item appears in queue Admin, capture the Event Begin Date/Time; identify the status of this event and determine when the status changes; capture the Event Begin Date/Time of the new status; and, find the span of time between these two date/times captured.

I've attached sample data, what I need, and the expected results. I posted this in the Formulas forum, but think I might have better luck in here...I'm hopeful anyway!!!

Anybody have an initial ideas/thoughts/tools you are aware of that does this type of work?

Thanks.