Work Shift Schedule

Employee RegisterEmployee RegisterHELPIDNameContracted HoursDepartment$ Hourly RateRTOTPHCH001David Brown40.00Accounts$ 15.00$ 22.50$ 30.00$ 600.00002Nichola Carter20.00Customer Support$ 12.00$ 18.00$ 24.00$ 240.00003James Oliver30.00HR$ 10.00$ 15.00$ 20.00$ 300.00004Nina Simon40.00Lobby/Reception$ 10.00$ 15.00$ 20.00$ 400.00005$ - 0$ - 0$ - 0006$ - 0$ - 0$ - 0007$ - 0$ - 0$ - 0008$ - 0$ - 0$ - 0009$ - 0$ - 0$ - 0010$ - 0$ - 0$ - 0011$ - 0$ - 0$ - 0012$ - 0$ - 0$ - 0013$ - 0$ - 0$ - 0014$ - 0$ - 0$ - 0015$ - 0$ - 0$ - 0016$ - 0$ - 0$ - 0017$ - 0$ - 0$ - 0018$ - 0$ - 0$ - 0019$ - 0$ - 0$ - 0020$ - 0$ - 0$ - 0021$ - 0$ - 0$ - 0022$ - 0$ - 0$ - 0023$ - 0$ - 0$ - 0024$ - 0$ - 0$ - 0025$ - 0$ - 0$ - 0026$ - 0$ - 0$ - 0027$ - 0$ - 0$ - 0028$ - 0$ - 0$ - 0029$ - 0$ - 0$ - 0030$ - 0$ - 0$ - 0031$ - 0$ - 0$ - 0032$ - 0$ - 0$ - 0033$ - 0$ - 0$ - 0034$ - 0$ - 0$ - 0035$ - 0$ - 0$ - 0036$ - 0$ - 0$ - 0037$ - 0$ - 0$ - 0038$ - 0$ - 0$ - 0039$ - 0$ - 0$ - 0040$ - 0$ - 0$ - 0041$ - 0$ - 0$ - 0042$ - 0$ - 0$ - 0043$ - 0$ - 0$ - 0044$ - 0$ - 0$ - 0045$ - 0$ - 0$ - 0046$ - 0$ - 0$ - 0047$ - 0$ - 0$ - 0048$ - 0$ - 0$ - 0049$ - 0$ - 0$ - 0050$ - 0$ - 0$ - 0When adding more rows, insert new rows above this one

Use this column to enter your employees hourly rate. Click HELP at the top left corner to read more.

The hourly rate which your organization pays to employees when working during Public Holidays. Click HELP at the top left corner to read more.

The hourly rate which your organization pays to employees for Overtime.Click HELP at the top left corner to read more.

Cumulative Rate (CR) which your employee receives for his/her contracted hours weekly.

Enter names of your organization employees.

Enter employee contracted hours in decimal format.

Select the department form drop-down list. To add/amend departments available in the drop-down list, click the Settings tab to add more departments. If you are not sure how to do it, click HELP at the top left corner to read more.

Work Shift ScheduleWork Shift ScheduleHELPWeek Commencing:Monday, June 24, 2013MondayTuesdayWednesdayThursdayFridaySaturdaySundayTotal of Special HoursTotal of Regular HoursOvertime HoursCost of Regular HoursCost of Overtime HoursSICKPHHOFFLOP 6OP 7OP 8OP 9OP 10AttendanceNameMondayTuesdayWednesdayThursdayFridaySaturdaySundayTotal TimeTime VarianceDepartmentSICKPHHOFFLOP 6OP 7OP 8OP 9OP 10SICKPHHOFFLOP 6OP 7OP 8OP 9OP 10SICKPHHOFFLOP 6OP 7OP 8OP 9OP 10SICKPHHOFFLOP 6OP 7OP 8OP 9OP 10SICKPHHOFFLOP 6OP 7OP 8OP 9OP 10SICKPHHOFFLOP 6OP 7OP 8OP 9OP 10SICKPHHOFFLOP 6OP 7OP 8OP 9OP 10HoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCostMondayTuesdayWednesdayThursdayFridaySaturdaySundayDavid Brown12:00 AM08:00 AM12:00 AM08:00 AM11:00 PM07:00 AMHHLLOFFOFFOFFOFF40:00;-40:00;--Accounts00.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0008.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0008.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0016:0024:0000.003600.000.0000.0000.0000.0000.0008.00120.0000.0000.0008.00120.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.001110000Nichola Carter12:00 AM02:30 AMOFFOFF12:00 AM08:30 AM12:00 AM08:30 AM12:00 AM02:30 AM12:00 AM08:30 AM05:45 PMOFF30:30;-30:30;-10:30;-10:30;-Customer Support10.5000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000:0030:3010.50366189.00189.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.001011111James Oliver12:30 AM09:00 AM11:00 PM07:30 AM10:00 PM06:30 AM12:00 AM06:30 AMOFFOFFOFFOFFOFFOFF32:00;-32:00;-02:00;-02:00;-HR02.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000:0032:0002.0032030.0030.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.001111000Nina SimonOFFOFF-40:00;-40:00;-Lobby/Reception-40.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000:0000:00-40.000-600.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000--00.0000:0000:0000.0000.000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000000000When adding more rows, insert new rows above this one

Time CardEmployee Time CardHELP1Employee Name:David BrownDepartment:AccountsWeek Commencing:Monday, June 24, 2013Before BreakInOutInOutMonday12:00 AM08:00 AMTuesday12:00 AM08:00 AMWednesday11:00 PM07:00 AMThursdayHHFridayLLSaturdayOFFOFFSundayOFFOFFEmployee SignatureManagers SignatureWeek Ending Date:Sunday, June 30, 2013Employee Name:Nichola CarterDepartment:Customer SupportWeek Commencing:Monday, June 24, 2013Before BreakBefore BreakInOutInOutMonday12:00 AM02:30 AMTuesdayOFFOFFWednesday12:00 AM08:30 AMThursday12:00 AM08:30 AMFriday12:00 AM02:30 AMSaturday12:00 AM08:30 AMSunday05:45 PMOFFEmployee SignatureManagers SignatureWeek Ending Date:Sunday, June 30, 2013

Salary BudgetSalary BudgetHELPWeek Commencing:Monday, November 30, 2009Current Week SalarySalary for:Average SalaryDepartmentNumber of EmployeesActualBudgetVarianceRegular HoursHolidaysPublic HolidaysLieu DayOption 6Option 7Option 8Option 9Option 10SickOffOvertime HoursActualBudgetAccounts1$ 600.00$ 900.00$ 300.00$ 360.00$ 120.00$ - 0$ 120.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 600.00$ 900.00HR1$ 320.00$ 300.00-$ 20.00$ 320.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 30.00$ 320.00$ 300.00Lobby/Reception1$ - 0$ 100.00$ 100.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 100.00Administration0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0Customer Support1$ 366.00-$ 366.00$ 366.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 189.00$ 366.00$ - 0Finance0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0Human Resources0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0IT0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0Marketing0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0R&D0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0Sales0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 04$ 1,286.00$ 1,300.00$ 14.00$ 1,046.00$ 120.00$ - 0$ 120.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ 219.00$ 321.50$ 325.00

Salary Distribution

Regular HoursAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales360.00000000000045320.0000000000005100366.00000000000006000000000000000HolidaysAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales1200000000000000000000Public HolidaysAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000Lieu DayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales1200000000000000000000OffAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000SickAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000Option 6AccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000Option 7AccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000Option 8AccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000Option 9AccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000Option 10AccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00000000000000000000

AttendanceAttendanceHELPWeek Commencing:Monday, November 30, 2009DepartmentMondayTuesdayWednesdayThursdayFridaySaturdaySundayAccounts111- 0- 0- 0- 0HR1111- 0- 0- 0Lobby/Reception- 0- 0- 0- 0- 0- 0- 0Administration- 0- 0- 0- 0- 0- 0- 0Customer Support1- 011111Finance- 0- 0- 0- 0- 0- 0- 0Human Resources- 0- 0- 0- 0- 0- 0- 0IT- 0- 0- 0- 0- 0- 0- 0Marketing- 0- 0- 0- 0- 0- 0- 0R&D- 0- 0- 0- 0- 0- 0- 0Sales- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0Average3232111AccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSalesMondayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales11001000000000000000Monday11001000000000000000Department00000000000000000000Monday11001000000000000000Department00000000000000000000Wednesday11001000000000000000Department00000000000000000000Wednesday11001000000000000000Department00000000000000000000Tuesday11000000000000000000Department00000000000000000000Tuesday11000000000000000000Department00000000000000000000Thursday01001000000000000000Department00000000000000000000Thursday01001000000000000000Department00000000000000000000Friday00001000000000000000Department00000000000000000000Friday00001000000000000000Department00000000000000000000Saturday00001000000000000000Department00000000000000000000Saturday00001000000000000000Department00000000000000000000Sunday00001000000000000000Department00000000000000000000Sunday00001000000000000000Department00000000000000000000

OccupancyOccupancyHELPWeek Commencing:Monday, November 30, 2009DepartmentMondayTuesdayWednesdayThursdayFridaySaturdaySundayAccounts100.0%100.0%100.0%----HR100.0%100.0%100.0%100.0%---Lobby/Reception-------Administration-------Customer Support100.0%-100.0%100.0%100.0%100.0%100.0%Finance-------Human Resources-------IT-------Marketing-------R&D-------Sales----------------------------------------------------------------------Average75.0%50.0%75.0%50.0%25.0%25.0%25.0%TuesdayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales11000000000000000000MondayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales11001000000000000000WednesdayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales11001000000000000000ThursdayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales01001000000000000000FridayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00001000000000000000SaturdayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00001000000000000000SundayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00001000000000000000SundayAccountsHRLobby/ReceptionAdministrationCustomer SupportFinanceHuman ResourcesITMarketingR&DSales00001000000000000000

SettingsSettingsSpecial DaysDep. CodeName of the DepartmentTime FormatCodeNamePaid Hours1Accounts12:00PM2SICKSick00:0000.002HR24:00PHPublic Holidays08:0008.003Lobby/ReceptionHHolidays08:0008.004AdministrationOvertimeOFFOff00:0000.005Customer SupportLLieu Day08:0008.006FinanceRegular Wage2OP 6Option 600:0000.007Human Resources1,5 of Regular Wage1.5OP 7Option 700:0000.008ITOP 8Option 800:0000.009MarketingPublic HolidaysOP 9Option 900:0000.0010R&DOP 10Option 1000:0000.0011SalesRegular Wage212Double Wage1314151617181920When adding more rows, insert new rows above this one

Time0:0012:00 AM0:1512:15 AM0:3012:30 AM0:4512:45 AM1:001:00 AM1:151:15 AM1:301:30 AM1:451:45 AM2:002:00 AM2:152:15 AM2:302:30 AM2:452:45 AM3:003:00 AM3:153:15 AM3:303:30 AM3:453:45 AM4:004:00 AM4:154:15 AM4:304:30 AM4:454:45 AM5:005:00 AM5:155:15 AM5:305:30 AM5:455:45 AM6:006:00 AM6:156:15 AM6:306:30 AM6:456:45 AM7:007:00 AM7:157:15 AM7:307:30 AM7:457:45 AM8:008:00 AM8:158:15 AM8:308:30 AM8:458:45 AM9:009:00 AM9:159:15 AM9:309:30 AM9:459:45 AM10:0010:00 AM10:1510:15 AM10:3010:30 AM10:4510:45 AM11:0011:00 AM11:1511:15 AM11:3011:30 AM11:4511:45 AM12:0012:00 PM12:1512:15 PM12:3012:30 PM12:4512:45 PM13:001:00 PM13:151:15 PM13:301:30 PM13:451:45 PM14:002:00 PM14:152:15 PM14:302:30 PM14:452:45 PM15:003:00 PM15:153:15 PM15:303:30 PM15:453:45 PM16:004:00 PM16:154:15 PM16:304:30 PM16:454:45 PM17:005:00 PM17:155:15 PM17:305:30 PM17:455:45 PM18:006:00 PM18:156:15 PM18:306:30 PM18:456:45 PM19:007:00 PM19:157:15 PM19:307:30 PM19:457:45 PM20:008:00 PM20:158:15 PM20:308:30 PM20:458:45 PM21:009:00 PM21:159:15 PM21:309:30 PM21:459:45 PM22:0010:00 PM22:1510:15 PM22:3010:30 PM22:4510:45 PM23:0011:00 PM23:1511:15 PM23:3011:30 PM23:4511:45 PMSICKSICKPHPHHHOFFOFFLLOP 6OP 6OP 7OP 7OP 8OP 8OP 9OP 9OP 10OP 10

HELPSpreadsheet123 Work Shift Schedule - Ver 1.0.31. Getting started with Work Shift ScheduleFirst thing first, before you dive into this template, we strongly recommend to make an additional copy of the file somewhere on your computer hard drive, in case if something went wrong.2. Hourly RatesGeneral InformationIn the UK some organizations, depending on the type of work schedule arrangement pay double of the regular hourly wage to their employees for agreeing to work during Public Holidays (Bank Holidays). In addition employees, who had worked during Bank Holidays are entitled to receive additional paid day-off known as "lieu day".See the following information on the official website of US Department of Labor:Overtime Pay - Wageshttp://www.dol.gov/dol/topic/wages/overtimepay.htmOvertime Pay - Work Hourshttp://www.dol.gov/dol/topic/workhours/overtime.htmFor additional information about work and wages during Public Holidays or to read more about Overtime, please follow the link to the article on WikipediaOvertimehttps://en.wikipedia.org/wiki/OvertimeSetting up Hourly RatesIn the UK some organizations, depending on the type of work schedule arrangement pay double of the regular hourly wage to their employees for agreeing to work during Public Holidays (Bank Holidays). In addition employees, who had worked during Bank Holidays are entitled to receive additional paid day-off known as "lieu day".Regular Time (RT) - The hourly rate, which your organization pays to employees per hour of their time at work. Depending on the contract, each employee is hired for a certain number hours that can be different and varies from 4 hours per week (legal minimum) to 40 hours (legal maximum). In some situations organizations might require their employees to work beyond their regular hours in a work week, which usually considered as Overtime and paid at a different rate, usually 1.5 of the regular time.Regulations are different for every country, so please check your countries employment laws and regulations before deciding on Overtime and Public Holiday hourly rates for your employees.Overtime (OT) - The hourly rate which your organization pays to employees for working beyond their contracted hours in a work week. By default, the hourly rate for Overtime is being calculated as one and a half of the regular hourly rate, this is optional and can be changed to regular rate in Settings.Public Holidays (PH) - The hourly rate which your organization pays to employees when working during Public Holidays. By default, the hourly rate during Public Holidays is being calculated as double of the regular hourly rate, this is optional and can be changed to regular rate in Settings.3. Adding more rowsA. Adding RowsTo add more rows to "Employee Register" and "Work Shift Schedule" worksheets simultaneously, you would need to group worksheets together by clicking on the "Employee Register" tab then press and hold the "SHIFT" button on your key board and click on the "Work Shift Schedule" tab. Next step is to insert a new row(s), right-click on the number reference of the row to select it and open contextual menu simultaneously and click "Insert", this will add a new row above the row which you have selected.B. Copying Formulas and Cell FormattingProvided that you have followed the steps described above, you can now copy all formulas into the added rows. Select one row above the newly added row(s), press and hold "SHIFT" key on your key board then press "Down Arrow" key to select the all empty rows below until you reach the last row above the row which is highlighted in grey. Once all necessary rows are selected, press "CTRL" + "D" keys on your key board, which will automatically copy formulas and cell formatting into the new rows.C. Ungrouping WorksheetsIt is necessary to ungroup all previously grouped worksheets before entering any data otherwise all entered data gets copied to every other worksheet within that group. Right click on any of the grouped worksheets tab and click "Ungroup Sheets" in contextual menu, which will appear.WARNING Remember to Ungroup Sheets after you have finished adding rows and copying formulas into them.WARNING Adding rows without grouping sheets may result in miscalculations and some cell formatting errors, unless you know what you are doing.4. Adding or/and amending departmentsIf you need to add or amend departments, you may do so by going to the Settings tab. By default, Work Shift Schedule has space for up to 20 different departments, but if your organization requires more then that, you can always add an additional row(s) above the last row on that list as displayed on the image below.5. Setting-up Special Days and paid hours for those days.You can set-up up to 10 special days and also assign paid hours for those days on the Settings tab. In default view, you will find 5 pre-assigned days with paid hours for those days, so that you can either continue with another 5 options or amend them in accordance with requirements of your organization.

Regular Time

Overtime

Cumulative Rate

Public Holiday

Regular Time

Overtime

Cumulative Rate

Public Holiday

http://www.dol.gov/dol/topic/workhours/overtime.htmhttp://www.dol.gov/dol/topic/wages/overtimepay.htmhttps://en.wikipedia.org/wiki/Overtime

EULATerms of Use - EULA 2013 Spreadsheet123 LTD. All rights reservedIMPORTANTREAD CAREFULLY:This End-User License Agreement (EULA) is a legal agreement between you and Spreadsheet123.com thatcovers all Microsoft Excel and OpenOffice.org templates or spreadsheets (TEMPLATES) and software ("SOFTWARE") madeby Spreadsheet123.com.By downloading, copying, accessing or otherwise using any TEMPLATES or/and SOFTWARE, you agree to be bound by theterms of this EULA.TEMPLATES LICENSEThis TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectualproperty laws and treaties. Each TEMPLATE is licensed, not sold.1. GRANT OF LICENSE.This EULA grants you the right to download this TEMPLATE free of charge for personal use or use within your companyor organization.You may customize this TEMPLATE with you personal information and use for its intended purpose in personal calculationsdocumentation or/and communications, but you may not remove or alter any logo, trademark, copyright, hyperlinks, disclaimers, terms of use or other proprietary notices within this TEMPLATE.You may not sell, resell, license, rent, lease, lend or otherwise transfer for value without writtenpermission of SPREADSHEET123.COMYou may not distribute this TEMPLATE in any stand-alone products that contain only the TEMPLATE, or as part of any other product. You may not copy or post any TEMPLATE on any network computer or broadcast it in any media withoutwritten permission of SPREADSHEET123.COM.2. RESERVATION OF RIGHTS.All title and copyrights in and to the Template, and any copies of the Template, are owned by Spreadsheet123.com. All rights not expressly granted are reserved by Spreadsheet123.com. In particular, this EULA does not grant you any rights in connection with any trademarks or service marks of Spreadsheet123.com. Use of any Template for any purposeother than expressly permitted in this EULA is prohibited, and may result in severe civil and criminal penalties.3. TERMINATION.Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with theterms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.4. NOTICE SPECIFIC TO TEMPLATES.SPREADSHEET123.COM MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIEDWARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLEAND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL,INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ANY REFERENCES TO EVENTS, PEOPLE, PLACES, OR ENTITIES IN THE TEMPLATES IS PURELY FICTITIOUS AND NOT INTENDED TO REPRESENT ANY ACTUAL EVENT,PERSON, PLACE, OR ENTITY. SPREADSHEET123.COM DISCLAIMS ANY LIKENESS OR SIMILARITIES TO ACTUAL EVENTS, PEOPLE, PLACES, OR ENTITIES, ANDANY SUCH LIKENESS OR SIMILARITIES ARE UNINTENTIONAL AND PURELY COINCIDENTAL.5. MISCELLANEOUS.Some states do not allow the limitation or exclusion of liability for incidental or consequentialdamages, so the above limitation may not apply to you.

Version UpdatesVersion Updates1.0.2January 15, 201224:00 and 12:00PM formating added for time table drop down values.1.0.2January 15, 2012Correction of error in the formulas that calculate daily attendance.