timesheet with running totals of overtime

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.

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.

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"
<kimmyrt@discussions.microsoft.com> 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.