Count hourly agents logged in

[maxanalyst]

So I have two tables as you can see in the attached excel sheet.
Sheet 1 has the employee login and logout time data.
And sheet 2 is just hours data. It is basically just hour start and end time with interval of one hour for each record.
Now I want to populate a third column in the 'Hourly data' sheet where I want to see number of agents (Agent Id column) logged in during that hour from the previous sheet.

The condition for being logged in during that hour is as follows:

LogInDateTime < 'Hour Start Time' and
LogOutDateTime > 'Hour Start Time' .

I think a formula with count should work but I am not sure about the conditions.
Any help is greatly appreciated. and if you have any questions you can reply in the forum.
Thank you in advance!