How to create staff levels for rota

[Dantekl]

Hi,

I'm working on staff rota and would like to show the levels per day. I'd like a cell to show there should be 4 per day and then if the levels vary to show minus, 0 , or plus accordingly as per the levels(-3,-2,1,0,+1,+2,+3, etc). I am using numbers and alphabets to denote shifts so finding it hard to create a formula that will give a result of a minus or plus. I have used data validation for the shift times. Hope it makes sense. I'm very new to excel.
Thank you.

 

[Mike H..]

Hi,

I'm working on staff rota and would like to show the levels per day. I'd like a cell to show there should be 4 per day and then if the levels vary to show minus, 0 , or plus accordingly as per the levels(-3,-2,1,0,+1,+2,+3, etc). I am using numbers and alphabets to denote shifts so finding it hard to create a formula that will give a result of a minus or plus. I have used data validation for the shift times. Hope it makes sense. I'm very new to excel.
Thank you.

Hi,

With the number of staff on duty in cell A1 this will return the - 0 +

=A1-4

 

[Dantekl]

This is how I'd like it to look
A staff names(about 10)
B,C,D,E,F etc days of the month
B1,B2,B3,C1,C2,C3 etc shifts per day
If less than 4 shifts covered per day then I would like it to show - 0 + in a designated cell

Thanks.