+ Reply to Thread
Results 1 to 2 of 2

Text & Numbers problem

  1. #1
    Trying to excel in life but need help
    Guest

    Text & Numbers problem

    I am putting together a schedule where each worker rotates weekly on a shift
    that is designated with numbers and text. Such as: 42 A, 42 B, 42 C, etc.

    It will be listed in order in a column beside the corrosponding date such as;
    The date will be in Column A, and the schedule will be in column B

    12/02/2005 42 A
    14/02/2005
    15/02/2005
    16/02/2005
    17/02/2005
    18/02/2005
    19/02/2005
    20/02/2005 42 B

    This will rotate like this every seven days between A,B,C shifts.

    Is there a formula have the A B C calculated atomatically. There are 300
    employees and 70 Shifts each with A,B,C and sometimes D shifts.

    Thank you in advance
    Martin

  2. #2
    Bob Tarburton
    Guest

    Re: Text & Numbers problem

    Probably can do but need quite a bit moe information.

    On Sat, 5 Mar 2005 13:01:02 -0800, "Trying to excel in life but need
    help" <[email protected]>
    wrote:

    >I am putting together a schedule where each worker rotates weekly on a shift
    >that is designated with numbers and text. Such as: 42 A, 42 B, 42 C, etc.
    >
    >It will be listed in order in a column beside the corrosponding date such as;
    >The date will be in Column A, and the schedule will be in column B
    >
    >12/02/2005 42 A
    >14/02/2005
    >15/02/2005
    >16/02/2005
    >17/02/2005
    >18/02/2005
    >19/02/2005
    >20/02/2005 42 B
    >
    >This will rotate like this every seven days between A,B,C shifts.
    >
    >Is there a formula have the A B C calculated atomatically. There are 300
    >employees and 70 Shifts each with A,B,C and sometimes D shifts.
    >
    >Thank you in advance
    >Martin



+ 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