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(D23:D29,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!!

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(D23:D29-80,D23:D29-8),0))}

--
Regards

Roger Govier


"Bianca" wrote in message
...
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(D23:D29,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!!

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

=IF(I30<40,0,IF(SUM(D23:D29)8,SUM(D23:D29)-8,"No Overtime"))

Vaya con Dios,
Chuck, CABGx3



"Bianca" wrote in message
...
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(D23:D29,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!!

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(D23:D29,"8")-(COUNTIF(D23:D29,"8")*8),I30-40)

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

Dave

"Bianca" wrote in message
...
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(D23:D29,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!!