+ Reply to Thread
Results 1 to 2 of 2

Employee Work Schedule

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2003
    Posts
    14

    Smile Employee Work Schedule

    I have an employee work schedule already generated. I need to set up the tabs on the bottom for every day of the week. I also have different shift listed from A to G. Example: A is Mon-Fri 6AM to 2:30 PM, B is Mon-Fri 8AM to 4:30PM, C is Tue-Sat 9AM to 5:30PM. I need a spread sheet that I can plug in the employees name and the shift they work in. Then also set up the days on the week on the tabs below. If I were to click on the Mondays tab it will show me who is working on that day. I need to also include a lunch time for each work group. Lunch is to be taken between the 4th hour and the 6th. Last but not least have 1 column to indicate of the employee is on vacation or called in sick. If the box is checked off it would shade in the employee name a different color. not sure if any one has something like this already set up. I have been trying different ways to set this up but can not figure it out. Please help...
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-02-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Employee Work Schedule

    Yes Really great information thanks for share it.

    Employee easily created your work schedule and other works on excel.

+ 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