Running Balance
Posted by Michelle on January 24, 2002 12:26 PM
I need a formula to keep a running balance. In one cell I have hrs calculated for the week, but I want to keep up with the total hrs. So, when the weekly hrs. change, it automatically adds to the total hrs, like this:
Total hrs for week - 40
Total hrs for month -40
and when I add next weeks hrs:
Total hrs for week - 40
Total hrs for month- 80
Total month hrs should increase everytime I put in the weekly hours.
Is this possible?
Posted by on January 24, 2002 3:10 PM
no
Total hrs for week - 40 Total hrs for month -40 Total hrs for month- 80
Posted by Bariloche on January 24, 2002 7:45 PM
By formula, no. By VBA, yes
Michelle,
The person who was so rude as to not post his name is correct. A fomula can't help you. If you would like a VBA solution, then it can be done. There is a solution that I posted on this board at this link.
If you'll give me specifics regarding your data set up I can modify that code to do what you need.
enjoy
Total hrs for week - 40 Total hrs for month -40 Total hrs for month- 80
Posted by Bariloche on January 24, 2002 8:02 PM
Correction: By formula, yes
Michelle,
Assuming your "Total hrs - week" are in cell B1, enter =B1+B2 into cell B2 and you should get the result you desire.
have fun
Posted by Bariloche on January 24, 2002 8:07 PM
Re: Correction: By formula, yes
I forgot to mention that you need to set "Maximum Iterations" to 1 in Tools > Options... > Calculation (check "Iterations").
If this solution is not acceptable, then we're back to using the VBA solution.
enjoy
Michelle, Assuming your "Total hrs - week" are in cell B1, enter =B1+B2 into cell B2 and you should get the result you desire. have fun
