Allocating lunches into a shift calculation

[ellebb85]

Hi,



I am looking for any ideas that could help me do the following.
I have a shift builder which when I input all shifts provides daily/interval service level predictions.

Within that I want to allocate lunch periods to staff but, I need a formula or set up that will look at all shifts and allocates the lunch periods equally throughout the day and within certain set parameters i.e minimum and maximum length worked before lunch can be scheduled.

I have been trying to think of ideas for some time but any ideas or suggestions would be appriciated.



Sent from my SM-N915FY using Tapatalk

[Pecoflyer]

Hi
please post a small sample sheet ( no pics please) showing what you have and desired results ( calculated manually eventually)