Hi, I am almost there with my spreadsheet, but need a little help.
See my attached sheet. all I need to do is:- My working week is 40 hours, I have calculated all my hours into travel, labour, office hours. I just need to calculate the amount of overitme based on the total for that week against standard 40 hours.
As the weeks go by, I will be adding a workbook for each week so will then need a running total for each segment.
Please can you help.
Bookmarks