Help with Adding 30 min break to function for Employee Schedule

So I'm in Florida working as a manager at a kiosk in a mall and I have a staff of 5 right now which includes myself(Sandra). I already have a function set for adding up hours worked throughout the week for each employee, but I need help coming up with an addition to my function.

So at our store anyone who works more than 7 hours gets a 30 min break. Also, any minor who works more than 4 hours gets a 30 min break.

Basically, I need need the "Total Hrs" column to reflect that. I have attached a file of the schedule that I am speaking of to this post. You can see who is a minor next to the names.

The break hours have been calculated on a daily basis. Minors after 4 otherwise 7. Take a look

Originally Posted by rcm

The break hours have been calculated on a daily basis. Minors after 4 otherwise 7. Take a look

Thank you much!

Originally Posted by FlameRetired

This would be a bit simpler for the Break hrs formula. Don't know why I didn't think of it before ... my apologies.

Formula:

Please Login or Register  to view this content.

This one worked great for me! I just had to change the 4/24 to 5/24 because if you work over 4 hours is when you get a 30 break