hi everyone, was wondering if you could help me

at the moment on my works schedules we only have the hours they are scheduled to work, what i was hoping to do was introduce a Break colunm to work out there breaks, but i was hoping that there would be a single forumla that would work out there break?

for example if someone works 4 hours they wont recieve a break, if they work over 4 hours but up to 7 they get 20 mins break and if they work 8 hours they get 30min break.

i hope this makes sense???

thanks in advance


will