I am trying to make a weekly work schedule for my employees that will show an In time, out time. Calculate the difference of hours with lunch breaks etc...

I found a post displayed below from 2009

I have to create a schedule which incorporates lunches automatically (either half hour or 1-hour lunches, depending on the circumstances).

The schedule only has time in and time out, but I need excel to automatically deduct the lunch break depending on the circumstance:

If you worked less than 6 hours = no lunch
If you worked more than 6 hours, but less than or equal to 8 hours = 0.5 hour lunch
If you worked more than 8 hours = 1 hour lunch

with this great answer
=(B2-A2)*24-IF((B2-A2)*24>8,1,IF((B2-A2)*24>6,0.5,0))

My problem is I need to do all this and also be able to have it Calculate "OFF" as 0 hours, and VAC as 8 hours. Is there some formula that can be combined with the one I found to accomodate my needs?

Thanks