Hi Mel,

I don't think this it's possible with just a formula. But you could use Power Query to allocate each ticket to a specific time slots during the day. Time slots that have more than 10 tickets simultaneously require your attention. In the attached file I connected to the table with the tickets and transformed it a bit in PQ.

As an example, I worked with 5-minute time slots and created a table where every ticket has the date, the time and the time slot. From there I created a pivot table and used conditional formatting to highlight time slots with more than 10 tickets in a given day. Expand the relevant field to display all tickets "active" during that time slot. These will be in number order, so the last one(s) came in latest and need to be billed.

See if this is something you could work with.

Riny

PS: I didn't attempt to make the queries very fancy. So, they are still quite crude.