How to make excel count based on time data?

[Halogen]

Hello there!
I'm sorry to bother you all, but I've been having trouble for about a week now on how to make this work in Excel 2016 and couldnt find a solution yet...

Here's what we got:
There's a lobby where people going in and out, in the left group of columns. We got exact time of their arrival and exiting on the right (screenshot included).
Is there any possible formula to make excel count how many people arrived, exited and visited lobby for every minute based on time data in the right columns?
Like, if there's a 08:44:38 and 08:44:43 on Entry column, it means two people got in and Arrived on 08:44 and becomes 2 in cell, If there's 7 matches on 09:01 on Exit column, it means 7 people got out and etc...


If you could help me out with this one i would really appreciate it!

 

[Bedlam]

Assuming Data is in Columns E and F and Analysis is in Column A and B use COUNTIFS Function
In cell b2 type =COUNTIFS(E:E,">="&$A2,E:E,"<"&$A3) [drag down]
In cell c2 type =COUNTIFS(F:F,">="&$A2,F:F,"<"&$A3) [drag down]

 

[Halogen]

Assuming Data is in Columns E and F and Analysis is in Column A and B use COUNTIFS Function
In cell b2 type =COUNTIFS(E:E,">="&$A2,E:E,"<"&$A3) [drag down]
In cell c2 type =COUNTIFS(F:F,">="&$A2,F:F,"<"&$A3) [drag down]
View attachment 107420

Yes, it worked!
Thank you very much!
And sorry for a bad english, not my native language!
Bless you!

 

[Fluff]

Welcome to the MrExcel Message Board!

For future reference.
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to make excel count based on time data?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.