+ Reply to Thread
Results 1 to 4 of 4

Rotating overtime call list

  1. #1
    Registered User
    Join Date
    12-03-2014
    Location
    San Bernardino, CA
    MS-Off Ver
    2013
    Posts
    5

    Rotating overtime call list

    I'm trying to make an overtime call out list at work. I have a list of employees (18 people) but I would like to have those who do not respond or say no be moved to the bottom of the call list to ensure that they are not called again until their name makes it back to the top. Anyone have a sheet for this already?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Rotating overtime call list

    Are there any other criteria ... such as cumulative number of hours turned down?
    Dave

  3. #3
    Registered User
    Join Date
    12-03-2014
    Location
    San Bernardino, CA
    MS-Off Ver
    2013
    Posts
    5
    Quote Originally Posted by FlameRetired View Post
    Are there any other criteria ... such as cumulative number of hours turned down?
    No other criteria.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Rotating overtime call list

    What if you set up a list like this ...


    A
    B
    1
    Name
    Date of Refusal
    2
    Rachel
    1/20/2017
    3
    Kelly
    2/6/2017
    4
    Allen
    2/20/2017
    5
    Joe
    3/17/2017
    6
    Susan
    3/19/2017
    7
    Sandra
    4/12/2017
    8
    Bob
    5/9/2017
    9
    Steve
    6/15/2017
    10
    Liz
    6/25/2017
    11
    Phyllis
    6/25/2017
    12
    Martha
    7/19/2017
    13
    Jacob
    8/12/2017
    14
    JoAnne
    8/21/2017
    15
    Mike
    8/27/2017
    16
    John
    9/13/2017
    17
    Elsie
    10/9/2017
    18
    Vince
    11/5/2017
    19
    Paul
    11/22/2017

    • Then select A2:B19
    • Tab over to make B2 the active cell
    • Sort those dates ascending

    The names will follow the date sorting 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] Rotating Overtime Schedule HELP!
    By MBowers2 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-28-2021, 01:18 AM
  2. (Solved) Rotating overtime list by hours?
    By crook038 in forum Excel General
    Replies: 10
    Last Post: 08-20-2017, 06:35 PM
  3. Rotating List
    By slydog75 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-13-2017, 10:16 PM
  4. Rotating overtime list
    By infernoboy93 in forum Excel General
    Replies: 1
    Last Post: 11-27-2014, 12:48 AM
  5. Create Rotating Overtime List
    By cay794 in forum Excel General
    Replies: 0
    Last Post: 08-11-2014, 02:01 PM
  6. Overtime, Mandatory, and Voluntary rotating schedules
    By Dreamcruz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-24-2013, 07:08 PM
  7. Overtime Rotating Seniority list.
    By duefs in forum Excel General
    Replies: 7
    Last Post: 07-25-2012, 11:17 AM

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