Shift Schedules

Based on the definition in wiki, shift work is an employment practice designed to make use of the 24 hours of the clock, rather than a standard working day. The term shift work includes both long-term night shifts and work schedules in which employees change or rotate shifts.

The common shift pattern are “the three shift system” where a day may be divided into three shifts, each of eight hours, and each employee works just one of those shifts; they might for example be 00:00 to 08:00, 08:00 to 16:00, 16:00 to 24:00. Generally, “first shift” refers to the day shift, with “second shift” running from late afternoon to midnight or so, and “third shift” being the night shift. On occasion, more complex schedules are used, sometimes involving employees changing shifts, in order to operate during weekends as well, in which case there will be four or more sets of employees. And there are some of websites provide a nice tool to help you managing your shift work schedules. And there are some simple excel spreadsheets also available that can be used to manage your shift.

Shift Work Schedules

The shift schedules I made is a weekly shift schedule for one week period and based on the condition that in one day period, a company might need two kind of shift patterns, usually it is applicable to retail stores, where one shift pattern is created for that retail store employee that have direct relation with customers, and the other shift pattern is applicable to its security people. And there are working hour calculator next to the name of shift worker to help you monitor the working hour of the worker whether it meets your company regulation or not.

Steps to use this spreadsheet are as follows (you can see the sample inside, and clear it once you start managing your shift):
1. Select your desired week period
2. Define your shift time for period 1 and 2
3. Type in the name, initial and title of your employee
4. Type in the title in the left column of shift schedule table
5. Select the the employee into the shift period table by selecting their initial
6. Watch the number of hour per week that will be revealed in employee table

I also put some conditional formatting that will reveal and hide cell line automatically once you type in, select or clear the column in shift schedule table. Feel free to modify or adjust the table to suit your needs.

You can download the file here.

There is a new shift schedule, released in August 2014, developed to help you automate all of your employee shift arrangement. You can read about the new employee shift schedule planner here or you can download and test the Lite version of the spreadsheet below.

  Employee Shift Schedule Generator (568.2 KiB, 41,031 hits)