Closed Thread
Results 1 to 2 of 2

monthly one shift work schedule

Hybrid View

  1. #1
    DasWerkes
    Guest

    monthly one shift work schedule

    We have Excel 2003 and would like to create a monthly one shift work schedule
    for about four employees with rotating weekends

  2. #2
    Mike
    Guest

    RE: monthly one shift work schedule

    Ummmm,
    b1 to h1 contains the seven days on a week
    a2 contains a date like whatever day Sunday is
    highlight a2 and drag your mouse down 100 some cells
    Click on Edit - Fill - Series - click on date and enter a step value of 7
    then click okay
    place the persons name our knickname when they work

    Click on File - Page Setup - Sheet - Rows to repeat at top enter
    $1:$1
    then click Okay.

    "DasWerkes" wrote:

    > We have Excel 2003 and would like to create a monthly one shift work schedule
    > for about four employees with rotating weekends


Closed 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