Please Help!

[Bianca]

I have a question about a spreadsheet that I'm doing for the office I need to
be able to compute over time hours for employees. So far what I have is:
=IF(I30<40,0,IF(D2329,>8,(D23-8,D24-8,D25-8,D26-8,D27-8,D28-8,D29-8))

Meaning that if I30 is less than 40 then 0 but if not then check if cells
D23 to D29 are over 8 hours for the workday if they are, then add up each
hour over 8 to come to the overtime hours. Can someone please help!!

 

[Roger Govier]

Hi Bianca

Try the ARRAY entered formula as below.
Commit with Control+Shift+Enter and Excel will insert the curly braces
{ }.
Do not type the braces yourself.

{=IF(I30<40,0,SUM(IF(D2329-8>0,D2329-8),0))}

 

[CLR]

Maybe this.............

=IF(I30<40,0,IF(SUM(D2329)>8,SUM(D2329)-8,"No Overtime"))

Vaya con Dios,
Chuck, CABGx3

 

[Dave]

Bianca

Maybe something like this. If the employee has less than 40 hours in the
week overtime will be paid on days with greater than 8 hours. If the
employee has more than 40 hours overtime will be paid on hours greater than
40

=IF(I30<40,SUMIF(D2329,">8")-(COUNTIF(D2329,">8")*8),I30-40)

If this is not what you are after please post back.

Dave