I have a table that contain a start date & time in column B and an end date and time in column C of different events, I need a formula to count how many rows fall within a certain time. For example below: I need to work out how many rows fall under a specific time being 13:00 each day, I can work out manually that for the 01/02/2019 13:00 2 of the below events will cross over this, can someone please help me with an equation?
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Event1[/TD]
[TD]01/02/2019 10:00[/TD]
[TD]05/02/2019 10:00[/TD]
[/TR]
[TR]
[TD]Event2[/TD]
[TD]03/02/2019 10:00[/TD]
[TD]04/02/2019 10:00[/TD]
[/TR]
[TR]
[TD]Event3[/TD]
[TD]01/02/2019 11:00[/TD]
[TD]03/02/2019 11:00[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]01/02/2019 13:00[/TD]
[TD]02/02/2019 13:00[/TD]
[TD]03/02/2019 13:00[/TD]
[/TR]
[TR]
[TD]Number of Events[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Event1[/TD]
[TD]01/02/2019 10:00[/TD]
[TD]05/02/2019 10:00[/TD]
[/TR]
[TR]
[TD]Event2[/TD]
[TD]03/02/2019 10:00[/TD]
[TD]04/02/2019 10:00[/TD]
[/TR]
[TR]
[TD]Event3[/TD]
[TD]01/02/2019 11:00[/TD]
[TD]03/02/2019 11:00[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]01/02/2019 13:00[/TD]
[TD]02/02/2019 13:00[/TD]
[TD]03/02/2019 13:00[/TD]
[/TR]
[TR]
[TD]Number of Events[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]