Thread: 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!!