Calculating Overtime

Press Esc to close

Question:

If the sum of cell A1 (Monday), B1 (Tuesday), C1 (Wednesday), D1 (Thursday), E1 (Friday), = >40 (hours) and F1 (Saturday) = >4 (hours) than H1 (Total Double-Time) = G1 (Sunday). How would I make this formula true so I can calculate my double time for my employees? I need it to calculate the total for sunday only if there are 40 hours or more monday through friday and more than 4 hours on saturday. Can someone please help me?

Answer:

Sure, put the following formula in H1

=IF(AND(A1+B1+C1+D1+E1>=40,F1>=4),G1,0)

 

Tags: IF AND

Enter your email and get everything you need to know about Excel Formulas!

Free Training Includes :

  • 54 Training Videos
  • 90-Second Formula Exercises
  • Detailed Exercise Solutions
  • And more
Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us