I played with the if formulas to first check if hours for the day will go make cumulative hours for week to go over 44, then a second check to see if total hours for day are greater than 8...I think this is working for calculating overtime per your requirements. Does it work for you?
Bookmarks