Excel 2007 : hours to break forumula?

[will46]

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

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.