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,
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee[/TD]
[TD]Check-In Date & Time[/TD]
[TD]Check-Out Date & Time[/TD]
[/TR]
[TR]
[TD]Employee 1[/TD]
[TD]11/26/15 1:29 AM[/TD]
[TD]11/26/15 2:38 AM[/TD]
[/TR]
[TR]
[TD]Employee 2[/TD]
[TD]11/26/15 4:35 AM[/TD]
[TD]11/26/15 6:45 AM[/TD]
[/TR]
[TR]
[TD]Employee 3[/TD]
[TD]11/26/15 10:31 AM[/TD]
[TD]11/26/15 12:40 PM[/TD]
[/TR]
[TR]
[TD]Employee 4[/TD]
[TD]11/26/15 10:38 AM[/TD]
[TD]11/26/15 11:45 AM[/TD]
[/TR]
[TR]
[TD]Employee 5[/TD]
[TD]11/26/15 1:17 PM[/TD]
[TD]11/26/15 2:55 PM[/TD]
[/TR]
[TR]
[TD]Employee 6[/TD]
[TD]11/26/15 8:24 PM[/TD]
[TD]11/27/15 12:30 AM[/TD]
[/TR]
[TR]
[TD]Employee 7[/TD]
[TD]11/26/15 8:39 PM[/TD]
[TD]11/27/15 12:30 AM[/TD]
[/TR]
[TR]
[TD]Employee 8[/TD]
[TD]11/26/15 8:40 PM[/TD]
[TD]11/26/15 11:30 PM[/TD]
[/TR]
[TR]
[TD]Employee 9[/TD]
[TD]11/26/15 8:40 PM[/TD]
[TD]11/27/15 12:36 AM[/TD]
[/TR]
[TR]
[TD]Employee 10[/TD]
[TD]11/26/15 8:40 PM[/TD]
[TD]11/26/15 10:10 PM[/TD]
[/TR]
[TR]
[TD]Employee 11[/TD]
[TD]11/26/15 8:45 PM[/TD]
[TD]11/27/15 12:36 AM[/TD]
[/TR]
[TR]
[TD]Employee 12[/TD]
[TD]11/27/15 7:55 AM[/TD]
[TD]11/27/15 10:55 AM[/TD]
[/TR]
[TR]
[TD]Employee 13[/TD]
[TD]11/27/15 9:00 AM[/TD]
[TD]11/27/15 9:45 AM[/TD]
[/TR]
[TR]
[TD]Employee 14[/TD]
[TD]11/27/15 1:13 PM[/TD]
[TD]11/27/15 2:30 PM[/TD]
[/TR]
[TR]
[TD]Employee 15[/TD]
[TD]11/27/15 4:30 PM[/TD]
[TD]11/27/15 7:14 PM[/TD]
[/TR]
</tbody>[/TABLE]
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!
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,
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee[/TD]
[TD]Check-In Date & Time[/TD]
[TD]Check-Out Date & Time[/TD]
[/TR]
[TR]
[TD]Employee 1[/TD]
[TD]11/26/15 1:29 AM[/TD]
[TD]11/26/15 2:38 AM[/TD]
[/TR]
[TR]
[TD]Employee 2[/TD]
[TD]11/26/15 4:35 AM[/TD]
[TD]11/26/15 6:45 AM[/TD]
[/TR]
[TR]
[TD]Employee 3[/TD]
[TD]11/26/15 10:31 AM[/TD]
[TD]11/26/15 12:40 PM[/TD]
[/TR]
[TR]
[TD]Employee 4[/TD]
[TD]11/26/15 10:38 AM[/TD]
[TD]11/26/15 11:45 AM[/TD]
[/TR]
[TR]
[TD]Employee 5[/TD]
[TD]11/26/15 1:17 PM[/TD]
[TD]11/26/15 2:55 PM[/TD]
[/TR]
[TR]
[TD]Employee 6[/TD]
[TD]11/26/15 8:24 PM[/TD]
[TD]11/27/15 12:30 AM[/TD]
[/TR]
[TR]
[TD]Employee 7[/TD]
[TD]11/26/15 8:39 PM[/TD]
[TD]11/27/15 12:30 AM[/TD]
[/TR]
[TR]
[TD]Employee 8[/TD]
[TD]11/26/15 8:40 PM[/TD]
[TD]11/26/15 11:30 PM[/TD]
[/TR]
[TR]
[TD]Employee 9[/TD]
[TD]11/26/15 8:40 PM[/TD]
[TD]11/27/15 12:36 AM[/TD]
[/TR]
[TR]
[TD]Employee 10[/TD]
[TD]11/26/15 8:40 PM[/TD]
[TD]11/26/15 10:10 PM[/TD]
[/TR]
[TR]
[TD]Employee 11[/TD]
[TD]11/26/15 8:45 PM[/TD]
[TD]11/27/15 12:36 AM[/TD]
[/TR]
[TR]
[TD]Employee 12[/TD]
[TD]11/27/15 7:55 AM[/TD]
[TD]11/27/15 10:55 AM[/TD]
[/TR]
[TR]
[TD]Employee 13[/TD]
[TD]11/27/15 9:00 AM[/TD]
[TD]11/27/15 9:45 AM[/TD]
[/TR]
[TR]
[TD]Employee 14[/TD]
[TD]11/27/15 1:13 PM[/TD]
[TD]11/27/15 2:30 PM[/TD]
[/TR]
[TR]
[TD]Employee 15[/TD]
[TD]11/27/15 4:30 PM[/TD]
[TD]11/27/15 7:14 PM[/TD]
[/TR]
</tbody>[/TABLE]
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!