rota

  1. S

    Excel Staff Rota

    I have a staff rota and want to input a date to show staff who are available to be called for cover. I have tried Index Match and Vlookup but my Excel experience falls short. I have an example spreadsheet but cant see how t upload?
  2. J

    IF functions with weekdays

    Hi guys. I have a Rota sheet that I'm doing some work on. I have an if function in to retrieve the data from the master Rota for each user if they are in that day. The issues I'm having is the coloum beside it. I want to put a formula in that says for example if b4 is not empty weekday is...
  3. T

    Highlight repeat words if within the next 2 or 3 consecutive rows and ignore blank cells?

    https://ibb.co/j4ZGeeHi there. I've searched on this forum and others for thisone but I can't seem to find it. I am by no means an expert with Excel so Iwould really appreciate some help. I am responsible for our rota at work. I have recently changed it to Excel fromWord to try and help me...
  4. R

    Conditional formatting to fill in blank cells based on adjacent cell

    I'm quite rusty with excel so could use some help. I've created a staff rota spreadsheet which tells people which department they'll be working in that day, and have a separate sheet that counts up this information to tell the management team how many people will be in any given department per...
  5. T

    Selecting names from one workbook and placing them in another workbook.

    Hello experts, I am hoping that this is not too big an ask? I have a workbook called weekend planning, I was wondering if it would be possible that when I add a date into the cells highlighted then it will cross reference with my engineering rota workbook and workout who is on shift for that...
  6. C

    Rota help needed with breaks

    Struggling to make this work for me, probable cause - complete novice. I'm changing roles and now need to be looking into creating rotas, I've created my template for it, but I need to take out 15 minutes (0.25) out of each shift over 5 hours for breaks. I cheated a little and did the...
  7. B

    Rota deducting lunch if shift over so many hours

    So I want to get a total amount of hours worked in a day, which takes away lunch of 30 mins if someone works 6 or more hours, what formula do I use? Cheers
  8. W

    Auto-populate ongoing rolling rota by date

    Hi All, My husband has an 8 week rolling rota and I'd like to create a spreadsheet where he can enter in the year and it will automatically fill the dates he's working and off. There are actually 8 teams, each with a different 8 week rolling rota so it would be good for a drop down to show the...
  9. B

    Counter formula for work rota

    Im trying to set up a rota in excel but need some help. I need a formula that will check if a cell contains letter E or L (early shift or late). Then at the bottom of table will add them up and display so i know how many people on each shift. Table will be peoples names down column A, then going...
  10. H

    Rota tool, criteria met.

    Hi Guys, I have an issue that i can't seem to get my head around. I have a tool that i use to determine how many staff i require to open my restaurant. With the manager starting at 07:00. The tool adds the following for each staff member starting; 07:00 = 1 08:00 = 0.75 09:00 = 0.5 10:00 =...
  11. Q

    conditional formatting

    Hi all, I am trying to make a cell highlight in red if there are more than 1 condition present. The table below represents a work rota and also a holiday planner underneath. The initials of each employee are entered into the rota for each day they are at work. If they are on a rest day (RD)...
  12. L

    Rota times

    I'm trying to do a works Rota with let's say 3 people starting at 6 oclcok 5 at 7 oclcok and 1 at 8 o'clock but I want to know the formula . Also I want it as 06:00 07:00 08:00 on the Rota so it's easier to see. 1/3/18 2/3/18 3/3/18 etc Person 1 06:00 Person 2...
  13. R

    Formula or VBA code to revert back to a formula if manually entered data is deleted

    Hi all, So basically I have created a spreadsheet to use as a rota calendar for work. I have used / changed a formula I found on another spreadsheet to automatically populate my calendar with the rota for the year, based on which rota is selected and the start date for that rota and the year...
  14. P

    Rota Form Help

    Hi I have a workbook that I have created for a rota. It runs for the full year with data being selected using a drop down. what im trying to do is create a userform which asks for the date, and based upon the date entered it searches through each worksheet (jan to dec) and displays the name of...
  15. T

    Rota start/finish times including a break

    Hi, I have an ongoing project where I fill in cells of scheduled work times for staff that results in displaying their start and finish times, sometimes over 7 hours and always 8 hours or more this will include a scheduled unpaid break so this time needs to be deducted. My current formula does...
  16. B

    VBA Index / Match?

    Hi, I have 2 worksheets, one called "Rota" & one called "Day Plan". Within the Rota worksheet, I have dates between B2:AE2, a list of names between A5:A7,A9:A17,A19:A24,A26:A35 and then various values between B5:AE35 Within the Day Plan worksheet, I have the same names but between...
  17. H

    add and remove rows for 5 week rota

    Hi Guys, I have a rota that has the entire year form 26/12/16 - 31/12/17 in column A from A2 down. I have a row from each date with shift codes and staff names. What I would like to achieve is to only show 5 weeks of rota and any given time. Is there a VBA to hide rows and unhide. So for...
  18. D

    Self Populating Rota

    I am attempting to create a rota, for weekday and weekend duties. I would like it to self populate based on two lists of names. The following rules need to apply; - Mon-Thurs - to automatically populate from the Senior and Junior Staff lists - Mon-Thurs - the on-call person must alternate...
  19. A

    Rota - Who's in on a specific date function

    Hi all! I'm having an issue working out how to summarise a who's in today function for a rota i'm working on. I've put a rough version up in the following location: https://docs.google.com/spreadsheets/d/1sjz7oDMGAeKEaQvIZU4ZsF4XcAJ95tHfM67NBoGRyUM/edit?usp=sharing As seen in the link above...
  20. M

    Help! calculating hours worked using a rota

    I have recently been given the work rota to take charge of and I am shocked that to this point everything is being manually input and worked out! what I have: an Excel sheet with a rota of days, list of venues on each day and which staff work there. staff move venues during the day, so may work...

Some videos you may like

This Week's Hot Topics

Top