J
JAGC
I am new at creating formula in Excel. I am trying to create a specific
timesheet. The employee can work a maximum of 70 hours in 7 days. I have
created this formula, which works for the pass 6 days but when I use it for 7
days, I have too many argument. I also have to create a formula for 13 days
and 14 days (maximum of 120 hours).
Works for pass 6 days:
=IF(D25=0,"0",SUM(IF(D20=0,(D21
25),IF(D21=0,(D22
25),IF(D22=0,(D23
25),IF(D23=0,(D24
25),IF(D24=0,D25,IF(D20
25>0,(D20
25),""))))))))
Too many argument (7 days):
=IF(D26=0,"0",SUM(IF(D20=0,(D21
26),IF(D21=0,(D22
26),IF(D22=0,(D23:F26),IF(D23=0,(D24
26),IF(D24=0,(D25
26),IF(D25=0,D26,IF(D20
26>0,(D20
26),"")))))))))
timesheet. The employee can work a maximum of 70 hours in 7 days. I have
created this formula, which works for the pass 6 days but when I use it for 7
days, I have too many argument. I also have to create a formula for 13 days
and 14 days (maximum of 120 hours).
Works for pass 6 days:
=IF(D25=0,"0",SUM(IF(D20=0,(D21
Too many argument (7 days):
=IF(D26=0,"0",SUM(IF(D20=0,(D21