+ Reply to Thread
Results 1 to 3 of 3

How to create simple formula in Excel for shift roster

  1. #1
    Registered User
    Join Date
    09-03-2009
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to create simple formula in Excel for shift roster

    Hi All,

    I need help to create a formula in Exceel to create shift roster, I am not good in this, can some one help me on this, critieria are mentioned below..

    Please send your answer to EDIT: removed by Mod

    1) Number of people

    6 Resources

    2) Number of people is each shift

    2 Resources

    3) Working hours and days working is it 12/5 or 12/7

    Monday: 2100 to 1400 ( next day) IST

    Tuesday: 2100 to 1400 ( next day) IST

    Wednesday: 2100 to 1400 ( next day) IST

    Thursday: 2100 to 1400 ( next day) IST

    Friday: 2100 to 1400 ( next day) IST

    Saturday: 1400 to 1400 ( next day) IST

    Sunday: 1400 to 1400 ( next day) IST



    In effect Monday to Friday 2100 to 1300 hrs ( next day)

    Saturday and Sunday 24x7





    2) Shift timings



    2100 hrs – 0600 hrs (next day)

    0500 hrs – 1400 hrs



    1400 – 2200 hrs (only on Saturday and Sunday)



    3) Frequency of change in shift (weekly or monthly)



    Whichever is easier - Preferably Weekly.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to create simple formula in Excel for shift roaster

    Mahaveer - all correspondence should be made directly through the board - it is after all a public forum.

    Note: I have also removed your mailing address, a) to comply with above but also b) to save you from being inundated with spam.

  3. #3
    Registered User
    Join Date
    10-29-2010
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: How to create simple formula in Excel for shift roaster

    Mahaveer, I know the Microsoft Office website provides some templates for shift rosters.

    This is what I found: http://office.microsoft.com/en-us/te...CT101172751033

    You could perhaps find a suitable template searching on the site.

    -Neil
    Shift Roster

+ 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