If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculate a running total
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 |
#2
|
|||
|
|||
calculate a running total
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 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 . |
Thread Tools | |
Display Modes | |
|
|