hwadesign.blogg.se - Spreadsheet employee schedule

Hope you will like this worksheet and for any shortcomings, you find please write in comments so that we can improve it to its best use.

For more weeks copy and paste this sheet to continue.

At the end, total working days along with total pay is calculated for each employee.

Fill this sheet for shifts of one week for all the employees.

Write “Sick” if an employee is absent for the reason.

For each day if an employee has performed his/her duty it will be count as “1” in the last column.

Just type “Continue” under the shift for which the employee is working.

For each employee enter his/her shift duty.

In the worksheet, it is given only six but you can add or remove as per your case. Left these timings if it is according to your requirement or change it to the timings you following at your workplace.

Three shifts timings are given by default.

You can still change this order as per your requirement.

The format is designed weekdays wise, starting from Monday to onward.

On the top right corner choose the week for which you want to maintain a record of shift rotation.

Open this file using Microsoft Excel Software.So extract it in your local computer folder to obtain Microsoft Excel. Download and save a copy of this template to your computer.Follow the instructions below to use this template for productive results. Here is given a work rotation schedule template that will help you do this task in a comprehensive way. To keep a record of shifts for each day becomes hectic if a proper schedule planner is not maintained.

An employee working in morning shift for one week can be put to evening shift for next week and hence for night shift for upcoming weeks. The practice followed for this type of working environment put employees to work at different shifts. Usually, three shifts are followed that comprises of 8 hours for each shift. At some places working schedule may keep continuing for 24 hours for which employees need to shift their duties at regular interval. Given work rotation schedule is helpful for all those managers who want to keep a record of different shifts and working hours of employees. How to use Employee Work Rotation Schedule Template