Can anyone help with this query?
e.g. I want to work out how many people are working at any time in a
24 hour period. The number of people rostered on differs each day of
the week.
Monday Time No. rostered on
6.00 2
7.00 2
8.00 2
9.00 2
10.00
(and so on)
Can I add additional staff number in my 'no. rostered on column' by
just entering the number into the cell.
Say, if there were an extra 2 staff starting their 8 hour shift at 9.
am. is there a way of just typing in '2' into that cell and getting
'4'?
What I do at the moment is enter =2+2 in that cell and the 7 cells
below. This is awfully tedious when calculating staff numbers for
every hour of a whole week.
Any help on this one would be appreciated.
Thanks very much
Janev
Allllen - 13 Sep 2006 13:17 GMT
Why don't you just add an extra 2 columns?
You would have it like this
> Mon Time Rostered Extra Total people
> 6.00 2 0 =SUM(C2:D2)
> 7.00 2 2 =SUM(C3:D3)
> 8.00 2 2 etc
You can type the number of extra people in the Extra column.

Signature
Allllen
> Can anyone help with this query?
>
[quoted text clipped - 26 lines]
>
> Janev
ufo_pilot - 13 Sep 2006 13:22 GMT
Is it possible to add a couple of extra columns after "No. rostered on"-column?
That would leave the next column to type i extra staff for that hour, an
then it will calculate the total for that hour in the column next to that.
col E
col F col G
Monday Time reg staff extra staff
6:00 2 0 =E2+F2
7:00 2 0 =E3+F3
(this is you total) 8:00 2 0 =E4+F4
=SUM(G2:G5) 9:00 2 2 =E5+F5
> Can anyone help with this query?
>
[quoted text clipped - 26 lines]
>
> Janev