Is there any way of calculating a running total within a single cell in a column
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 |
Is there any way of calculating a running total within a single ce
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. -- Allllen "Janev" wrote: 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 |
Is there any way of calculating a running total within a single ce
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 "Janev" wrote: 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 |
All times are GMT +1. The time now is 06:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com