I am having issues in creating a new schedule document for work. I insert the associates name, when they arrive and when they leave. I would like for the spreadsheet to not only determine the number of hours that they work but also the length of break that they will receive.
If the associate works more than or equal to 5 hours they receive a 30 minute break.
If the associate works less than 5 hours they receive only a 15 minute break.
I have attached an example to better show what I am working with and the formula that I am currently trying to use.
Bookmarks