Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Janev - 13 Sep 2006 12:51 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.