TIMESHEET HOURS CALCULATION
Budget: £20 – £250 GBP
Uses the day and date to determine hours worked on a shift.
Daytime hours are 0600-2000hrs during the week
Nighttime hours are 2000hrs-0600hrs during the week
Saturday hours are midnight to midnight
Sunday hours are midnight to midnight
Bank holiday hours are midnight to midnight
SATURDAY HOURS AND NIGHT HOURS CAN BE COMBINED INTO ONE TOTAL (SAME RATE)
SUNDAY HOURS AND BANK HOLIDAYS CAN BE COMBINED INTO ONE TOTAL (SAME RATE
Breaks taken during the shift are deducted from the longest portion of the shift.
We export a spreadsheet which produces the report attached (excluding the calculation of the breakdown of hours). I am looking for an easy way to paste something to the export (which we do several times a week) and it will calculate the breakdown of hours according to the above, also looking up whether days are bank holidays etc.
The file uploaded shows how the calculations should work - this has been done manually, we are looking to automate it.
Daytime hours are 0600-2000hrs during the week
Nighttime hours are 2000hrs-0600hrs during the week
Saturday hours are midnight to midnight
Sunday hours are midnight to midnight
Bank holiday hours are midnight to midnight
SATURDAY HOURS AND NIGHT HOURS CAN BE COMBINED INTO ONE TOTAL (SAME RATE)
SUNDAY HOURS AND BANK HOLIDAYS CAN BE COMBINED INTO ONE TOTAL (SAME RATE
Breaks taken during the shift are deducted from the longest portion of the shift.
We export a spreadsheet which produces the report attached (excluding the calculation of the breakdown of hours). I am looking for an easy way to paste something to the export (which we do several times a week) and it will calculate the breakdown of hours according to the above, also looking up whether days are bank holidays etc.
The file uploaded shows how the calculations should work - this has been done manually, we are looking to automate it.