Break Overage Calculation for Part time employee

[apmcirose]

I am having a hard time figuring out a formula. I am new and learning excel so I am very much a noob.

I have a part time person who works 5 hours which is 300 minutes. They are allowed 15 minute break with a 10 minute leniency. So below is the formula I am using:
I have attached the spreadsheet and highlighted the row I am having problems with.

[DJunqueira]

Could be it?

Please Login or Register  to view this content.

[apmcirose]

Thanks. Not where I highlighted. I am looking at more Part Time Employee gets 15 min. If they take anything over that the overage must be shown and I am looking for it to show me what percentage of the overage as compared to the break it is. Is it 9% of the break that was over or more. Hope this helps.

[DJunqueira]

I hope somebody else help you, I just didn't get the idea how your spreadsheet works.