Calculating overtime hours on a timesheet

I thought I had everything worked out with this timesheet but I've discovered one more problem. Weekly Timesheet.xlsx The total overtime hours needs to show that anything over 40 hours in the Total Regular Hours cell is overtime. And it also needs to show only up to 40 hours in the Total Regular Hours cell. How do I fix this?

Hi

Perhaps put some data in the time sheet and make a note on the sheet as I do understand what you mean! It seems to work OK.

Weekly Timesheet.xlsx
Okay, I added what amounts to 49.50 hours. What I'd like to see happen is this... G18 should read no higher than 40 and H18 should include all overtime and read 9.50. Is there a way to do this?

Hi tiffany04530

See the attached.

Kevin.....not sure what you changed.

Hi tiffany04530

I have changed the formulas in G11:GG17 & H11:H17. They are a bit long! But now Saturdays and Sundays go in the overtime column.

That would be great if they always worked M-F but what about if there is an employee that had a regularly scheduled day on Saturday or Sunday?

Hi

Then personally I think you need to redesign your spreadsheet then, because how does one know which days are regular time for each employee!