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

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,630
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,122,755
Messages
5,597,929
Members
414,193
Latest member
bb60

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