Is there any way of calculating a running total within a single cell in a column

  • Thread starter Thread starter Janev
  • Start date Start date
J

Janev

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
 
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
Click to expand...

You can type the number of extra people in the Extra column.
 
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
 
Back
Top