Staff

joeino

New Member
Joined
Oct 28, 2020
Messages
5
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Hi,

New to excel and would like to seek your help.

Here is what I have.

Time table from 12:00 AM to 11:30 PM on a 30 minute interval
List of names (ColA)
Shift Start time (ColB)

What I want to do is to populate the time table and check how many staff I have on each interval. Shift lasts for 9 hours (i.e. 12:00AM to 9:00AM). So if I have 3 that will start at 12:00AM, 4 at 6:00AM and 2 at 10:00AM, the result on interval 10:00am should be 6 since the ones who started at 12:00AM is already done with their time.

So far, I can do countif to count the number of staff that will start on a specified time but can no longer proceed :(

Cheers!
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,651
Add finish times in column C.

=B2+"09:00"

With a time to query in E2 use:

=COUNTIFS(B:B,"<="&E2,C:C,">="&E2)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,454
Messages
5,601,764
Members
414,471
Latest member
cchunyadi

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
Top