Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if and then formula | Excel Worksheet Functions | |||
Locking portions of a formula | Excel Worksheet Functions | |||
Cost to Retail Price Formula - some help pse | Excel Worksheet Functions | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions |