+ Reply to Thread
Results 1 to 2 of 2

Daily Rotating Schedule

  1. #1
    Registered User
    Join Date
    08-22-2017
    Location
    Houston, Texas
    MS-Off Ver
    2010
    Posts
    1

    Lightbulb Daily Rotating Schedule

    Hi!

    I'm not too excel savvy, and I'm in a pickle. I work for an outpatient clinic. We typically see the same clients every day. There is a daily schedule created - daily - most of the time it changes multiple times during the day due to client cancellations or employee call outs. Our scheduler currently doesn't have any type of formula on her excel sheet. She manually changes it, and it may take her up to 3 hours to compile a schedule. I was wondering if it were possible to create a schedule that can auto populate with the following constraints:
    Client Schedule
    Employee Schedule
    What clients an employee can work with
    Typicall 2 hour time blocks

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,556

    Re: Daily Rotating Schedule

    Hello cinexel and Welcome to Excel Forum.
    It would help us to attempt to help you if you could upload a desensitized sample of your scheduler's spreadsheet/workbook. Set up a mock scenario of what types of changes might occur and how she would handle those changes manually. In that way someone here may be able to write formulas and/or code that would automate the process.
    To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Rotating Overtime Schedule HELP!
    By MBowers2 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-28-2021, 01:18 AM
  2. [SOLVED] Rotating Schedule advice
    By gtaaccord in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-08-2018, 03:52 AM
  3. Rotating schedule
    By danmac444 in forum Excel General
    Replies: 1
    Last Post: 04-10-2017, 03:53 PM
  4. Rotating Schedule
    By melbessetti in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2015, 02:22 PM
  5. [SOLVED] Rotating work schedule
    By Luigi802 in forum Excel General
    Replies: 2
    Last Post: 02-06-2015, 11:14 AM
  6. Create a rotating Schedule
    By redrock1979 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2013, 03:21 AM
  7. Creating a Rotating Schedule
    By rburke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2013, 03:28 AM

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