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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post