kimm

Chip Pearson has done all the work for you.

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


Gord Dibben Excel MVP

On Mon, 24 Jan 2005 15:07:06 -0800, "kimmyrt"
wrote:

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.