+ Reply to Thread
Results 1 to 1 of 1

Excel for shifts of areas and times

Hybrid View

barbara70 Excel for shifts of areas and... 12-10-2016, 01:54 AM
  1. #1
    Registered User
    Join Date
    12-10-2016
    Location
    Italy, bologna
    MS-Off Ver
    2013
    Posts
    1

    Excel for shifts of areas and times

    Hi guys, I would need a big hand for the creation of an automatism to create shifts of times and areas, with the following characteristics:
    * 11 people
    * 6 zones: B, C, D, E, Jolly, PHONE
    * 2 presence in the area B, C, D, AE, PHONE
    * Presence 1 JOLLY
    * All zones are working from Monday to Friday
    * Work on Saturdays: the presence of 2 persons (no assigned area)
    * JOB HOURS:
    - PHONE 7-15: 30 (2 persons)
    - Opening 7 - 15:30 (1 person)
    - Opening postponed 7: 30-16 (1 person)
    - Early closure 9 - 17:30 (1 person)
    - Closing 10 - 18:30 (1 person)

    I am attaching the file I used this year, but pointed out that not all boys mate, there are technicians who do not 'meet' ever and the guys do not turn in the same time period, for the same number of times .

    Thanks
    Attached Files Attached Files

+ 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. Replies: 8
    Last Post: 03-24-2016, 08:13 PM
  2. vb script for making an excel for workers's shifts
    By aihibihi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2015, 01:18 PM
  3. Not able to add shifts to excel template
    By wings00192 in forum Excel General
    Replies: 3
    Last Post: 03-27-2014, 07:17 PM
  4. [SOLVED] Count rows between two areas in a collection/selection of multiple areas
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2012, 10:38 AM
  5. Search spread sheet of times and areas to find discrepancies.
    By nohowb4 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2012, 01:36 AM
  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. Excel shifts to wrong worksheet automatically
    By Tom77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2005, 05:06 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