Create a running totals of hours

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 30 Mar 2004 10:50 GMT

I would like step by step instructions on how to create a
running total balance for a timeesheet i have created in
Excel. The columns i am using are Start, End,Hours and
running totals. I would like to know how to fix my
worksheet to calculate automatically the hours as i put
them in the hours column to give me a running total in the
next column. Thank you

Reply to this Message

David McRitchie - 31 Mar 2004 06:34 GMT

Hi Rick,
Take a look at
http://www.mvps.org/dmcritchie/excel/datetime.htm

You probably take out for lunch, but since you did not say so.

D2: 7:00
E2: 16:00
F2: =E2-D2+(D2>E2)
G2: =F2

D3: 23:00
E3: 8:00
F3: =E3-D3}+(D3>E3)
G3: =OFFSET(G3,-1,0)+F3 -- use fill-handle to copy formula down
you can double-click on the fill handle if there is something to the left
http://www.mvps.org/dmcritchie/excel/fillhand.htm

Reason for use of OFFSET in totals
http://www.mvps.org/dmcritchie/excel/insrtrow.htm#offset

You can find sample time sheets in Chip Pearson and John Walkenbach's
pages. You will find links on my datetime.htm page.
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> I would like step by step instructions on how to create a
> running total balance for a timeesheet i have created in
[quoted text clipped - 3 lines]
> them in the hours column to give me a running total in the
> next column. Thank you

Reply to this Message