Grouping tickets by time entered

[ST4RCUTTER]

Here is my problem. We stage outages once 3 tickets have been recieved for the same problem type, but only if all three tickets are entered within 16.65 hours or 999 minutes. I.E. the third ticket is received within 999 minutes of the first ticket. How can I capture this based on the field time entered?

 

[grnzbra]

Create a "Top 3" query based on the time entered and check if the time of the first record is within the criteria time of the last record.