Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What formula should I use to calculate overtime hours for my particular spreadsheet in Excel?

April 26, 2017CALCULATE Computers Excel Formula hours internet overtime particular Software spreadsheet

0

Posted

What formula should I use to calculate overtime hours for my particular spreadsheet in Excel?

1 Answer

0

Posted

if overtime is based on 40 hoursw a week, then you dont want to calculate column J on a daily basis (what if you work 9 hours on monday, and 7 hours on tuesday, and 8 hours wed,, thur,, & fri. you would use an if() statement to calculate OT if your weekly total is in cell I8 (should be =SUM(A1:A7) your regular pay is 2 your overtime pay is 6 then use this formula in J8 =IF(I8<40,I8*2,(40*2)+((I8-40)*6)) it says if i8<40 then just multiply i8*2 otherwise you get paid for the full 40 hours at the regular rate (40*2) plus you get the difference over 40 at the OT pay then do the same thing for the 2nd week. and add the 2 totals together.