Results 1 to 6 of 6

formula for creating a shift pattern

Threaded View

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    5

    formula for creating a shift pattern

    Hi Guys, I'm a total newbie and I have followed an on-line tutorial on how to build a employee roster, I have a list of example employees in the
    roster and on each month in the employee section I have a drop down box where I can choose the appropriate employee and it will fill in their
    clock number etc, etc., but what I want to do is on another pager create a drop down box with the names and then enter a shift pattern for each
    person and a start date and then it will fill the roster you with that persons shift.

    I know this is a lot to ask but is this possible?

    Also can you give my roster the once over to let me know if I need to modify anything?

    thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a pattern formula for a specific list
    By julskool2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2014, 12:09 PM
  2. [SOLVED] I need a formula to calculate a cost for a shift pattern
    By rjassal82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-22-2013, 11:43 AM
  3. Formula to calculate personel numbers during a shift pattern
    By nigo75 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2013, 12:10 AM
  4. Replies: 4
    Last Post: 02-06-2013, 04:21 AM
  5. [SOLVED] Would like to automate creating new 3 shift pattern
    By rosshkerr in forum Excel General
    Replies: 7
    Last Post: 08-19-2012, 04:20 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