Help with complicated Excel Formula

I am working on making an electronic time card for my employees. I need excel to find the sum of “straight time” worked. The problem is that the employee gets over time for anything over 40 hours a week. The time card combines the 2 weeks into one easy to read time sheet for me. I have tried to calculate multiple time and it is not returning what I need it to return.  I will gladly email you a copy of the file to work with and help me try to figure out the problem. 

 

 

Thank you 

By: Dustyn

One thought on “Help with complicated Excel Formula

  1. Jason

    Have you tried using SUMIFS formula
    It would sum based on criteria . Here your criteria would persons name, week worked

Leave a Reply

Your email address will not be published. Required fields are marked *