How to Choose Your
Excel Expert Type...
Select the field of expertise that best matches your question so we can assign the appropriate expert to handle your question. If you don’t know - select 'General Expert'.
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?
Sure, put the following formula in H1