+ Reply to Thread
Results 1 to 5 of 5

staff rota

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    staff rota

    hi i have been currently looking for software that will allow me to add staff names and conditions such as no less than 5 staff a day ect. is there anything out there in excell that allows this


    big ask i know but thought i may aswel ask before looking elsewhere

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: staff rota

    Staff rotas can be made in Excel but you have to describe your problem a lot more detailed than that.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: staff rota

    Have you tried googling for

    Excel free staff rota template

    There appear to be many offerings.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    Re: staff rota

    Hi here is some more detailed info

    There are 18 staff
    All work 5 days over 7
    shift types ,0800 - 1600 & 1230 - 2030
    if possible to have both days of together
    Also work same amount of saturdays/sundays
    Monday - Friday numbers need to be at least 7 early starts & 7 late
    Sat/sun numbers can be 6/5
    Hope this helps

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: staff rota

    Hi,

    Did you look at any of the free templates on the web. I note too that there are numerous Employee templates that are available within Excel. Just choose File New and then look in the Employees templates folder.

    If none of these are any use then as a minimum you should design your own layout and add some typical data along with some notes that explain the limitations that you have imposed. For instance I don't know what you mean, or to be more precise how YOU define early and late starts.

+ 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: 14
    Last Post: 05-23-2015, 06:26 AM
  2. Staff rota help required
    By NPC1977 in forum Excel General
    Replies: 2
    Last Post: 01-29-2015, 07:08 AM
  3. Staff rota
    By chelfox in forum Excel General
    Replies: 1
    Last Post: 10-07-2013, 11:25 AM
  4. Staff Rota
    By parkey5 in forum Excel General
    Replies: 5
    Last Post: 07-14-2013, 04:16 AM
  5. Creating a staff rota
    By daustin3 in forum Excel General
    Replies: 0
    Last Post: 05-16-2012, 12:30 PM
  6. staff rota with holiday
    By Lebowski25 in forum Excel General
    Replies: 0
    Last Post: 07-30-2010, 06:32 AM
  7. Staff rota
    By goofy14you in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2007, 04:13 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