How to create a formula for 35 minute breaks...

Hello, I am new to this whole Excel thing. I have been receiving help from a friend and my Brother In Law. However, they have been busy and are unsure of how to help me in this matter.

First of all, I need to mention that I no longer have Excel at my home computer, I am using Open Office (which I am not used to yet.) I have Excel at work which is where I need the help.

I am trying to make an Employee Schedule that has hours worked for each individual Employee as well as Total Hours worked for each Day. My friend worked out a formula for that, however, some other Managers I work with are being difficult and now want to know if it's possible to minus out their 35 minute breaks. Which would need to be minused out for each Employee as well as each individual day.

For each shift that is scheduled more than 5 hours they get one 35 minute break. So if someone is scheduled for 5 hours exactly or less they would not receive a break. If someone is scheduled for a double shift they would receive two 35 minute breaks.

I hope this isn't too much. Thanks for any help you can give me.

I will attach the schedule I have so far.

Sincerely,
Tricia