Staff

[joeino]

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!

 

[mrshl9898]

Add finish times in column C.

=B2+"09:00"

With a time to query in E2 use:

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

 

[joeino]

Add finish times in column C.

=B2+"09:00"

With a time to query in E2 use:

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

Awesome! Thanks for the help!