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

Hi again,

I'm sorry I just got the chance to review this closely, looks like it doesn't capture everything, e.g. 24:00-24:59 is 0 when there are guests at this time frame. Thanks again.