calculate a running total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 30 Mar 2004 11:01 GMT

I need to calculate a running total on an excell
worksheet. I am doing this for a timesheet. The columns
i will have are Start, End, Total, Runnig total
example : 11:00pm 7:00am 8 8
9:00pm 1:00am 4 12

This is how i would like to work it. Can you help me with
step-by-step instructions ? I am not very computer saavy
so please explain in simple english if possible. Thank you

Reply to this Message

JudithJubilee - 30 Mar 2004 12:17 GMT

In the second cell of your Running Total column you need
to add a formula to add the one above it to the one to the
left of it.

If your spreadsheet below starts with Start in A1 then the
formula in cell D3 will be =D2+C4 . You can then drag the
formula down the column using the Fill handle.

Hope this is what you mean
Judith

>-----Original Message-----
>I need to calculate a running total on an excell
[quoted text clipped - 7 lines]
>so please explain in simple english if possible. Thank you
>.

Reply to this Message

Rate this thread: