@bricks96 this is exactly what I'm looking for, thank you. To take it one step further, instead of the time interval being days, what if I wanted it to be working hours?

So if my employee receives an order at 2pm on Wednesday and completes it at 4pm on Monday the next week, that would be 29 working hours, assuming a 9-hour workday. How do I change the sequence part of the formula to essentially consider each unique hour of every day the case is being worked?