Gurus of excel.
Before I start I have attached an example sheet for better understanding.
I am building a timesheet to track the following:
- Total Time worked.
- Time worked over 40 hours
- Breakdown of the type of work undertaken.
- Holidays taken
- Total time less holidays.
I am using a SUMIF to get bulletpoints 1 & 3
Formatting seems to be letting me down for Time over 40 hours
I want to know if there is a simple way of discounting the holiday hours? Although this sample is basic and shows only holidays I also have to include flexi time taken etc.
Bookmarks