+ Reply to Thread
Results 1 to 1 of 1

Staff Scheduling

Hybrid View

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    Edmonton, Alberta
    MS-Off Ver
    2016
    Posts
    65

    Staff Scheduling

    Hello,
    I am trying to come up with a staff schedule using excel.
    I have 5 staff members and need '24/7' coverage* (there will be 2 hours per day where coverage is provided by another area which we do not have to schedule for - 5am to 6am, and 5pm to 6pm).

    Day Shift is 6am to 5pm (11 hours including a 1 hour unpaid lunch)
    Night Shift is 6pm to 5am (11 hours including a 1 hour unpaid lunch)
    On weekdays, during the day there needs to be an additional staff member working. Day Shift (2) is 7am to 4pm (9 hours including a 1 hour unpaid lunch).

    Maximum hours per week is 40 paid hours, each staff member should be paid 70 hours per bi-weekly period.

    A rotating schedule over a period of weeks is acceptable.

    I'm unsure where to begin with this.

    I have included an example (attached). The first chart is one bi-weekly period of the current schedule, the second chart is to be the proposed new schedule, the third chart is the daily coverage. All of the hours listed include a 1 hour unpaid lunch.
    Attached Files Attached Files
    Last edited by EWolfe; 10-22-2018 at 12:08 PM.

+ 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. [SOLVED] Staff clock data conversion into time table per staff member
    By PhilSkil1609 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2017, 04:33 PM
  2. [SOLVED] Count the number of staff working between times based on staff position
    By sparky1978 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2016, 08:10 AM
  3. [SOLVED] Macro to update Score Card Summary when the new staff add-in or existing staff deleted
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2014, 02:43 PM
  4. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  5. Scheduling: Calendar style scheduling based on scheduling list
    By denkatprieto in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2012, 11:10 AM
  6. Staff scheduling
    By BRISBANEBOB in forum Excel General
    Replies: 3
    Last Post: 01-28-2011, 08:42 AM
  7. [SOLVED] Scheduling Field Staff using Excel (perhaps Networkdays function)
    By Toxman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2005, 01:55 PM

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