Formula- count # of guests for every hour based on arrival and end time

Hello,

I am trying to count the # of guests there were at every hour from arrival to end/departure time. All are night guests and most were there past midnight.

I used the formula suggested in one of the threads here but it's giving me negative results and/or not accurately counting guests.

Thanks in advance for your valuable help.

Jomejorada