rota

HI, I'm looking for a VBA solution to automatically populate an on call rota please. The rota should be filled according to the following rules: Only 1 staff member for each day Staff member can't be on 2 consecutive days weekdays are allocated separately from weekend days. This is to ensure...

Hi, I'm trying to create a new rota for my workplace [Google Sheets – image below- Column D needs to be a total number of nonblank cells, but only if they're not any of SICK, HOL, SAB, OFF, MAT, PAT, R/O. (So in that image, it would just be 4). I'm currently using...

Hi All, Say I have a restaurant and need certain staff on different tasks each night. We try to make it so that each member of staff perform each job at some point in the week. I want to avoid one member of staff being in the pair that for example washes pots 3 days a week when everyone...

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?

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...

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...

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...

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...

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...

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

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...

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...

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 =...

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)...

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...

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...

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...

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...

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...

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...