Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: 3 Team 8 Hour Rotating Shift Schedule Generator

  1. #1
    Join Date
    13th August 2017
    Posts
    11

    3 Team 8 Hour Rotating Shift Schedule Generator

    I am trying to create a 3 team (2 employees per shift) 8 hour(08:00 -16:00 - Day, 16:00 - 00:00 = Swing, 00:00 - 08:00 - Night) with weekend on call rotating shift schedule generator in a calendar format in excel. I also want to be able to use the same spreadsheet for years after. Example 2017, 2018, 2019, etc

    For example, if Bert/Argenis are on day shift (8am - 4pm), they will also be on call for the whole weekend (Sat. and Sun.).

    I would also like to be able to make the schedule for the rest of the year.

    Thank you in advance.
    .


    .

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,188

    Re: 3 Team 8 Hour Rotating Shift Schedule Generator

    Welcome to Ozgrid.

    This forum is really for help with a specific bit of worksheet structure, formula or VBA code that a person, who is creating their own workbook, is stuck on. If you want a complete workbook designed and automated from scratch then you should consider posting in the Hire Help forum. http://www.ozgrid.com/forum/forumdisplay.php?f=105
    We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

  3. #3
    Join Date
    13th August 2017
    Posts
    11

    Re: 3 Team 8 Hour Rotating Shift Schedule Generator

    Thank you. I will post it there.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 1
    Last Post: May 23rd, 2016, 13:55
  2. Shift Schedule patterns
    By GenEng in forum Excel VBA / Macros
    Replies: 2
    Last Post: April 11th, 2016, 21:53
  3. Rotating Overtime Schedule
    By MBowers2 in forum Excel General
    Replies: 1
    Last Post: September 9th, 2013, 16:55
  4. Calculate Number of people on shift each hour
    By daveyboy in forum Excel General
    Replies: 5
    Last Post: August 25th, 2011, 06:34
  5. Replies: 9
    Last Post: September 6th, 2006, 07:05

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
  •  
porno