I am trying to do a Timesheet for a group of people in Excel 2016.
South African law prescribe the calculation of overtime, double time and night shift allowance.
Overtime = hours worked more than 9 hours per day.
Double Time = work on Sundays or Public Holidays.
Night Shift Allowance = hours of work between 18:00 and 6:00.
Can somebody help with the formula to do the calculation per day.
Attached is a sheet used to enter the data per day and this is then added to the database from where all reports and dashboards are done.
Regards
Bookmarks