shifts

Hi I have just completed a work schedule for 2018 January to December. I have used the count if formula to count the total Holidays, total shifts, and sickness for each month. I need help as I need to count shifts for 4 weekly pay period as suppose to monthly. not sure if this is...

hello ive been trying for years to get an answer on this: This is what i would need help with. i have the following shifts on any GIVING DAY REQUIRED. Am cook, Pm cook, am1, am2, am3, pm4, pm 5 & pm6 i would like a formula that if any of these shifts are missing on any giving day a...

Hi There This is probably a very simple thing, but I am no excel expert and am wondering if someone could suggest a formula. I have an employee schedule. Some employees have set rotations of shifts and others do not. I have assigned them all a number to start with based on the lines that they...

I have a feeling this might be a linear programming problem. What I'm trying to do is work out the best combination of the yellow cells which are head counts. The total shifts should be as close as possible to the "required shifts". It doesn't matter if we're a bit over or a bit under, just as...

Hi all. Hopefully you can help me. Say for example in A1 to G1 i have Sunday through to Saturday. In A2 to G2, i put the number of hours a colleague is due to work for the day above. If the colleague isnt due to work, i leave the cell blank In another part of the spreadhsheet, say H1 to H8 i...

Hello All, I am running a formula that will count the number of employees scheduled at a particular time. (Each formula references a different hour). In addition to what is an incredibly long formula, I now have discovered that if a shift is scheduled to end past 23:59, then the entire shift...

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

I am having a hard time finding anything that specifically addresses my situation. I have staff that work with clients. Typical shifts will be on a single date, but occasionally, hours will cross midnight. Service codes can vary, and staff may work 12pm-5pm with one service and 5pm-8pm with a...

i am doing a project for school on the lottery. my problem is that i have formulas that reference to cells A1:A10. everytime there is a lottery draw i import the new numbers to cell A1, this causes the previous data to shift down one cell, which is what i want. however the formuals that...

We've turned to 3 shifts instead of two. I have 3 groups of people who change shifts regularly, Group A - Group B - Group C , groups swap shifts with each other So they will go forward 1 shift. week1: A B C Week2: C A B week3: B C A ... then again A B C....etc. .I would like something that...

I am recording my work schedule in a money spreadsheet, I have all of the data for shift date, time, hours, pay, money, etc. Then in a new chart I am representing Weekly Values such as number of shift, hours, and money. I have the weeknum function as a pivot and then I was able to manipulate the...

I have a work schedule in excel using the date of the shift, the time, and the money made and so on, if I were to make weekly totals, how would I make a good equation for the total of shifts, hours, and money made? I was thinking countif but i dont know how to encompass all of the dates in a...