timesheet with OT

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

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:
 
Back
Top