Concurrent Users Count Formula/Logic Help

[btx99]

Hi All,

I'm trying to figure out how many concurrent users there are in office for each day. Column A is Check-in date and time, and Column B is Check-out date and time. Every row is an individual.

For example,

Employee	Check-In Date & Time	Check-Out Date & Time
Employee 1	11/26/15 1:29 AM	11/26/15 2:38 AM
Employee 2	11/26/15 4:35 AM	11/26/15 6:45 AM
Employee 3	11/26/15 10:31 AM	11/26/15 12:40 PM
Employee 4	11/26/15 10:38 AM	11/26/15 11:45 AM
Employee 5	11/26/15 1:17 PM	11/26/15 2:55 PM
Employee 6	11/26/15 8:24 PM	11/27/15 12:30 AM
Employee 7	11/26/15 8:39 PM	11/27/15 12:30 AM
Employee 8	11/26/15 8:40 PM	11/26/15 11:30 PM
Employee 9	11/26/15 8:40 PM	11/27/15 12:36 AM
Employee 10	11/26/15 8:40 PM	11/26/15 10:10 PM
Employee 11	11/26/15 8:45 PM	11/27/15 12:36 AM
Employee 12	11/27/15 7:55 AM	11/27/15 10:55 AM
Employee 13	11/27/15 9:00 AM	11/27/15 9:45 AM
Employee 14	11/27/15 1:13 PM	11/27/15 2:30 PM
Employee 15	11/27/15 4:30 PM	11/27/15 7:14 PM

<tbody>
</tbody>

I can manually go through and tick off (number is 6 for concurrent users in office on November 26th). Is there an easy formula to determine this?

Any help/info would be great.

Thank you!