Concurrent Users Count Formula/Logic Help

btx99

New Member
Joined
Apr 24, 2016
Messages
1
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!
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top