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?
<tbody>
</tbody>
<tbody>
</tbody>
Event1 | 01/02/2019 10:00 | 05/02/2019 10:00 |
Event2 | 03/02/2019 10:00 | 04/02/2019 10:00 |
Event3 | 01/02/2019 11:00 | 03/02/2019 11:00 |
<tbody>
</tbody>
01/02/2019 13:00 | 02/02/2019 13:00 | 03/02/2019 13:00 | |
Number of Events | 2 | 2 | 2 |
<tbody>
</tbody>