In cell E2 enter

=E1+D2

then copy down for each week

--

HTH

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


"kimmyrt" <kimmyrt@discussions.microsoft.com> wrote in message
news:B40D66A8-2737-41D4-B746-F316BFBD25DE@microsoft.com...
> 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.