timesheet with OT
 

I am trying to make a simple timesheet, if I figure it out a little better I
will expand it, that will add over time. I just want to add up the 7 days,
cells A1-A7 and put that total in cell A9 {=SUM(A1:A7)} in cell A10 I would
like it to not do anything until columns A1-A7 go over 40, I would then like
the number 40 to stay at 40 in cell A9 then put anything over that in cell
A10{=SUMIF(A9,"40")-40} sort of like this. Is their a way to keep the
"-40" in cell A10 "invisable" until it goes over 0? And to stop the 40 in
cell A9 from going over 40? Thanks.

A9: =MIN(SUM(A1:A7),40)
A10: =MAX(0,SUM(A1:A7)-40)

Regards,
Stefi

€žmike€� ezt Ã*rta:

I am trying to make a simple timesheet, if I figure it out a little better I
will expand it, that will add over time. I just want to add up the 7 days,
cells A1-A7 and put that total in cell A9 {=SUM(A1:A7)} in cell A10 I would
like it to not do anything until columns A1-A7 go over 40, I would then like
the number 40 to stay at 40 in cell A9 then put anything over that in cell
A10{=SUMIF(A9,"40")-40} sort of like this. Is their a way to keep the
"-40" in cell A10 "invisable" until it goes over 0? And to stop the 40 in
cell A9 from going over 40? Thanks.

Stefi wrote:
A9: =MIN(SUM(A1:A7),40)
A10: =MAX(0,SUM(A1:A7)-40)

Regards,
Stefi

"mike" ezt írta:

I am trying to make a simple timesheet, if I figure it out a little
better I will expand it, that will add over time. I just want to
add up the 7 days, cells A1-A7 and put that total in cell A9
{=SUM(A1:A7)} in cell A10 I would like it to not do anything until
columns A1-A7 go over 40, I would then like the number 40 to stay at
40 in cell A9 then put anything over that in cell
A10{=SUMIF(A9,"40")-40} sort of like this. Is their a way to keep
the "-40" in cell A10 "invisable" until it goes over 0? And to stop
the 40 in cell A9 from going over 40? Thanks.

Thanks!!