Need a formula to help job cost Please help!
 

I have been trying for the past 2 weeks to develop a formula that will
calculate overtime for workers. I have got as far as this formula
={IF(D30<40,0,SUM(IF(D23:D29-80,D23:D29-8),0))}
But the problem with this formula is that it only calculated overtime when a
worker works more than 8 hours in one day. So for example in the case that
the employee works
monday=10 tuesday=8 wednesday=8 thursday=10 friday=8 saturday=8 sunday=8

then on this formula would only calculate 4 hours of overtime because monday
and tuesday they worked 2 extra hours. but the formula doesn't take into
account that 440 hours into the day friday this employee's 5th hour and so on
were overtime because he exceeded 40 hours.
So what I need is a formula that WHEN and IF an employee exceeds 40 hours
then sum all hours over 8 a day. All I need is regular hours and total hours.
Thanks so much

Need a formula to help job cost Please help!
 

assuming D30 is the total weeks hours
=IF(D30<=40,0,D30-40 )


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=560102

Need a formula to help job cost Please help!
 

this could work
=IF(D238,D23-8)+IF(D248,D24-8)+IF(D258,D26-8)+IF(D268,D26-8)+IF(D278,D27-8)+IF(D3040,D28)+IF(D3040,D29)


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=560102