+ Reply to Thread
Results 1 to 2 of 2

shift schedule

  1. #1
    Registered User
    Join Date
    05-14-2010
    Location
    telford,tn
    MS-Off Ver
    Excel 2003
    Posts
    1

    shift schedule

    Hi, I am trying to make a Saturday to Friday excel sheet for a deli schedule and make sure I have coverage along with giving days off.
    Here are the shifts I am trying to use for a 5 day work week for each employee sometimes they need extra days off so that is why I put primary, secondary and optional
    5am-2pm primary
    6am-3pm secondary
    9am-6pm optional
    10am-7pm primary
    12pm-9pm secondary
    2pm-11pm secondary
    2pm-11pm primary
    2pm-11pm primary

    I have 10 employees.
    will later have 15 employees and more hours to give during the holidays so I need to have room to grow in the excel sheet

    thanks
    I need a formula to move the schedule around when a shift is replaced or a formula with a drop down with all the available shifts left for that day
    I think what I am looking for is a addin that would have all the choices for each day but I am not sure how it would cross reference across and down
    Attached Files Attached Files
    Last edited by fmgarner; 05-16-2010 at 11:49 AM. Reason: needed more information to get help

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: shift schedule

    What is the question?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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