+ Reply to Thread
Results 1 to 5 of 5

Schedule with Split Shifts, and Sort by times in/out

  1. #1
    Registered User
    Join Date
    12-19-2018
    Location
    Austin, TX
    MS-Off Ver
    Office 365
    Posts
    3

    Schedule with Split Shifts, and Sort by times in/out

    Hi there, first time posting, but I've been using excel for several year, but not very advanced, nor taken any classes.
    I created this workbook today that I want to use at work.
    In the first sheet, it is simply a schedule that has been copied and pasted from our store's scheduling program, so can't change the formatting on that
    I have a blank page on how the daily sheets are formatted.
    Then on each page, i have the appropriate data pulled from the full schedule starting with column Z. The tables (not Excel Tables) for each type of position have formulas that extract the data from the daily schedule which fill in only the names of the people scheduled for that day, and their shift.

    The problem I've run into, and not sure where to start, is that there will occasionally be split shifts, as you can see with Monday and Tuesday.
    Manager 3 has a split shift on monday, but the monday sheet is only displaying the first shift.
    Manager 1 has a split shift on tuesday, same problem.

    Then, what I'd like to do, is have each area of the sheet sorted first by the in times of the employees, and then the out times
    Attached Files Attached Files
    Last edited by russellm84; 12-19-2018 at 07:10 AM. Reason: Reattaching file with names removed/changed

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Schedule with Split Shifts, and Sort by times in/out

    This routine will fill all the days with the shifts
    I am also including your excel file with the routine and link included. The button is in the schedule ranges tab.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-19-2018
    Location
    Austin, TX
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Schedule with Split Shifts, and Sort by times in/out

    Thanks for that, but it seems to be copying the same shifts to every day, instead of the appropriate day to each sheet. I don't know what the code is doing in order to find what I need to fix

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Schedule with Split Shifts, and Sort by times in/out

    My bad. It was not looking at the right columns. I fixed it. Give it a try.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-19-2018
    Location
    Austin, TX
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Schedule with Split Shifts, and Sort by times in/out

    Thank you. I actually figured out a formula based solution using ranking based on the in times of the employees. Then I used a helper column next to each field on the sheet to fill in the schedules using ranks in ascending order

+ 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] Saturday Work Schedule - 28 Advisors - 8 Shifts
    By SVTF in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2018, 12:12 AM
  2. CA Alt Work Schedule/Day-Night shifts Timesheet
    By GinaMB in forum Excel General
    Replies: 5
    Last Post: 12-28-2016, 06:52 PM
  3. Work Schedule - 24/7 - 4 shifts per day, 6 people
    By as519999 in forum Excel General
    Replies: 3
    Last Post: 04-06-2015, 07:33 PM
  4. Replies: 0
    Last Post: 09-23-2014, 09:30 AM
  5. 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
  6. Use Excel to Schedule Employee Shifts
    By er1c1o19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2009, 07:50 PM
  7. [SOLVED] Set up schedule for 3 different shifts
    By Tina in forum Excel General
    Replies: 0
    Last Post: 04-27-2006, 04:10 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