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