Request assistance on a query

[sa7toot]

Dear all,
I have a sheet containing a list of sales processed by a salesman during a period of time. I need to do an analysis to find out the number of sales done by each salesman on the same PC during a specific period of time. Basically, I need to answer these questions:
1- How many sales done by each salesman on the same PC during 1 hour during a calendar?
2- How many sales done by each salesman on the same PC during 30 minutes a calendar day?
3- What is the number of salesmen who have done 5 or more sales within 1 hour during a calendar day?
4- What is the number of salesmen who have done 5 or more sales within 30 minutes during a calendar day?

Can this be achieved using a macro?

 

[bassplr19]

Use a Pivot table

 

[sa7toot]

Use a Pivot table

A pivot table won’t work. The time frame here is not bound by the hour. It could be 13:12 until 14:12 where the criteria matches.