+ Reply to Thread
Results 1 to 4 of 4

Work Schedule - 24/7 - 4 shifts per day, 6 people

  1. #1
    Registered User
    Join Date
    04-06-2015
    Location
    Halifax, NS
    MS-Off Ver
    2013
    Posts
    2

    Question Work Schedule - 24/7 - 4 shifts per day, 6 people

    Hello,

    I am having great difficulty coming up with a schedule.

    Here is what we need:
    • Day1 - 7:30am - 4:30pm
    • Afternoon1 - 3:30pm-12:30am
    • Backshift1 - 11:30pm - 8:30am
    • Day 2 - 7:30am - 4:30pm

    Day1, Afternoon1 and Backshift 1 are needed 7 days a week, but Day2 is needed only Monday to Friday.

    We have 6 people to cover all shifts!

    Any help would be appreciated!!

  2. #2
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Work Schedule - 24/7 - 4 shifts per day, 6 people

    What are the objectives of your schedule other than to man these hours? You have a total of 234 man-hours to cover with six people. Are you trying to avoid paying anyone overtime past 40 hours? What else?

  3. #3
    Registered User
    Join Date
    04-06-2015
    Location
    Halifax, NS
    MS-Off Ver
    2013
    Posts
    2

    Exclamation Re: Work Schedule - 24/7 - 4 shifts per day, 6 people

    I want to give all employees an even amount of hours (or as even as possible). I want to avoid anyone going over 48 hours in a week. No employee working more than 6 days in a row.

    In an idea world the schedule would be a rotation of 5 days on, 3 days off, except after working the backshift they would get 4 days off. However I have not been able to come up with a schedule that works for that so I am open to variations.

  4. #4
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Work Schedule - 24/7 - 4 shifts per day, 6 people

    I can't think of any way to do that without having a couple shift jumpers per week... and thinking about how to do that is giving me a headache (

    Perhaps someone else has a way...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 09-23-2014, 09:30 AM
  2. Work Schedule, 10hr Shifts, 4 on 3 off, Rotating Weekends Off
    By onflight1978 in forum Excel General
    Replies: 5
    Last Post: 12-21-2012, 03:38 PM
  3. Use Excel to Schedule Employee Shifts
    By er1c1o19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2009, 07:50 PM
  4. [SOLVED] monthly work schedule for 2 people on same calendar
    By roadbitch in forum Excel General
    Replies: 0
    Last Post: 05-18-2006, 08:20 AM
  5. Set up schedule for 3 different shifts
    By Tina in forum Excel General
    Replies: 0
    Last Post: 04-27-2006, 04:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1