Formula to determine Schedules

**paconovellino** · 10-10-2013, 07:51 PM

I'm using Excel to create staffing on 30 minutes interval.

Column "A" has intervals from 00:00 - 23:30.
Column "B" has the # of staff needed on each of the intervals.

They all work a 10 hours shift and I would like to be able to know the schedules needed for each. I've attached a sample sheet if that helps. Any assistance would be greatly appreciated.

Schedules.xlsx

**FDibbins** · 10-10-2013, 08:09 PM

Your file includes the time range and a list of quantity of staff - what would your expected outcome look like? (in other words, Im not really sure what you want to do?)

**paconovellino** · 10-11-2013, 02:23 PM

Staff works 10 hours a day so I want the outcome to look something like this
6:00 - 16:00
6:00 - 16:00
6:00 - 16:00
6:30 - 16:30

And so on. The tricky part is that at 16:00 you need to subtract the persons how had worked 10 hours.