Counting values in a time range - when the time range crosses midnight

Hi,

I receive data from 2 different programs in an excel format and I am trying to count the number of appointments performed by a person in Table1 during a specific time period in table 2. I have been reasonably successful when the hours are with the same 24hr period but I am having trouble crossing the midnight barrier, for example how many scans in table 1 were performed during the time period 23:50 to 00:40 in table 2. Any suggestions would be much appreciated.

Thanks