timesheet with running totals of overtime

[Guest]

Hi, I'm trying to create a very simple time sheet by weeks, not days. column
A is employees name, B is the week worked, C is total hrs. for that week, D
is hrs. short or over 40 hrs., and E is a running total of the hrs. short or
under 40 hrs. a week. I just need a formula to enter so I can just punch in
the times in C and then D and E will come up. If anyone can help it would be
extremely appreciated, or even let me know if such a formula exists. If you
need me to send you the timesheet I can, its really small. I'm not to good
at explaining these things. Thanks so much in advance.

 

[Bob Phillips]

In cell E2 enter

=E1+D2

then copy down for each week

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

kimm

Chip Pearson has done all the work for you.

See at http://www.cpearson.com/excel/overtime.htm


Gord Dibben Excel MVP