I'm new to post here so I apologize ahead of time if this topic has already been discussed and answered. I am trying to create a timesheet that will calculate if hours worked on a Saturday would be overtime based on the total hours worked Mon-Fri. Saturday work shall only be deemed overtime if 40 or more hours have been worked during the week. Anytime worked over 40 hours will be considered overtime whether it occur during the week or on Saturday. For instance if an employee worked 38 hours during the week and 6 hours on Saturday, 2 hours would be considered straight time and 4 hours overtime. I can't seem to get the correct formula for each column. Thanks.