JS514HR ◉ SHIFT SCHEDULE GENERATOR | 2 GROUPS | 2 SHIFTS

$19.00

GOOGLE SHEETS & EXCEL VERSION

$19 | Multi User |  

Pay Once | Use Forever

Instant Download

 

Description

EMPLOYEE SHIFT SCHEDULE GENERATOR is an shift schedule spreadsheet that will generate weekly work rotation for one full year automatically. It has work-hour calculator that will calculate total work hours per week based on generating schedule and duration of shift hours that you set.

This is the version that will generate shift based on 2 employee groups and 2 shift period. There are 6 popular shift patterns that you can choose :

  1. Early and Late 5 On No Rotation
  2. Early and Late 5 On Week Shifting
  3. Early and Late 5 On 2 Week Shifting
  4. Early and Late 6 On No Rotation
  5. Early and Late 6 On Week Shifting
  6. Early and Late 6 On 2 Week Shifting

If you already have your own shift pattern, you can use the custom table to map your own.

You can put maximum 50 employees and distribute them into each groups (max 20 employees per group). You can assign different number of employees per group.

You can set it to any dates, but it should fall on Monday.

All shift periods will be marked with different color markers in printable employee attendance calendar where you can identify their shift easily and put leave codes, overtime etc in particular table or fields and summarize it in your report.

This shift schedule generator should fit you who are looking for an automated shift schedule generator that are working in Excel or Google Sheets.

Shift Schedule Generator - 2 Groups 2 Shifts

What you will get

You will get :

  • One ready to use Excel spreadsheet that you can use in Excel or upload to Google Sheets
  • One Excel spreadsheet filled with dummy data for reference

 

Requirement

Microsoft Excel 2007, 2010, 2013, 2016, 2019 for Windows Vista, 7, 8, 10

Microsoft Excel 2008, 2011, 2016, 2019 for Mac OS X

Google Sheets