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

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

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

Hi Folks, I'm devising a new dual rota at my work and I want to automate it as much as possible. We have two offices and a mixture of experienced and newer staff. The rota will consist of Primary and Secondary staff (in columns D & E) and I have put staff names into the following named ranges...

Hi guys I have created a timesheet for my crew that will work out how many hours worked each day and then work out their pay. At the moment i've done it for one shift per day, however, i need it to be for two just incase. Can anyone advise me the formula to use. I currently have...

Hello. With my very limited knowledge of excel I have been creating a shedule for the company I am employed by. Now, however, my GCSE ICT has met an impass. Allow me to break down the problem. Attached, you will find a copy of this shedule. As you can see, there are many employees and many...

Hello, I've had help creating a decent rota for my staff for a small cafe. I'm happy for people to use what I've got for themselves, so download the file and go for it. What I'd love, is a separate tab whereby I can have a input a date range, and it tells me the hours the staff member has...

hi, i am making a rota where on a given day the days hours are entered in as 7 - 3 which is 7 am to 3 pm is there a way i can get excel to return a value in the next cell as the number of hours worked as in this case 8 hours

Hello, I have a rota sheet whereby shifts are written in as start time, finish time, and then a calculation for the hours. At the bottom I have another SUM formula to calculate total daily hours. However, within the total personal hours I have a VLOOKUP formula to check if the start time cell...

I am trying to create a 14 day rota for staff with desk numbers assigned and want to calculate how many people are in in the office and how many desks are free daily.

Hello, hoping for some advice please. I am looking to set up a shift rotation planner for a charity I am involved with, and am not sure if I should be attempting this in Excel or if because of the number of potential volunteers/requirements I should be looking at separate software. Details as...

Dear Excel Community, I run an events company operating Christmas grottos throughout the UK. Key to what we do is the rostering of staff. I have an Excel template, into which on the first tab I put the opening hours of grottos and it will populate the correct shift patterns for Santa and his...

Hello everyone and anyone that can help. I'm looking for some help to calculate holiday hours using an "H", or meeting hours using an "M", in a time cell instead of an hour to state that it is a holiday day, and distinguishing these hours from standard working hours to create two different...

Hi I need help in setting up an excel sheet which can do the following for me: We have 13/14 employees who need to supervise the call centre each day. Each working day has two shift, 8-1pm(AM shift) and 1 to 6pm(PM shift); therefore we use 1 employee 1 shift cover methodology. I need to build...

Hi everyone, i dont have in depth knowledge of excel but have been trying to build a rota worksheet from scratch, but i am stuck now. I have a master rota which has everyone's ideal shifts and a weekly rota, i have copied master to weekly so when i put in a time on 1 it updates the other and...

Hi, I'm in need of assistance! I have a very limited knowledge of VBA (just starting) and I'm looking for guidance on a project. A 4 weekly rota that takes into account several perameters: How many staff are needed that day. Column S Whether an employee has asked for a day off. +16...

Hi guys, I come to you seeking much help. I have gone way beyond my excel knowledge and have now been landed with a task which I cannot do!:confused: I want to create a Staff Rota which can calculate the following Hours worked in shift, hours worked in day also needs to deduct breaks upto...

I am looking to create a roster generator that will calculate the number and length of shifts required to ensure we have enough staff throughout a day. I dont wont to recreate a wheel that already exists nor do I want to attempt to create a wheel that cannot exist, but any help would be much...

Hi all My wife has got two jobs in the caring profession and I'd like to help her keep on top of what families she works with as in, who, where, where and if on a regular weekly basis, bi-weekly basis, monthly etc. It's getting quite complicated keeping track so any help would be appreciated...

Hi I am trying to create an auto table in excel for a daily work schedule for my employees. I would like to have the names of employees in colomn "J". addded to a table on the left automatically. Each employee would start and end at different times given in columns "K" & "L", and must have...