Hello, I'm working on a timesheet, and I currently have it working so that if
for ex:

Someone clocks in at 8:00am, lunchs out at 12pm, lunchs in at 1pm, and clock
outs at 5pm, it calculates the time they were on the clock. Also if for that
day SAT, SUN, or Nothing is entered, it calculates no time (or a blank). See
formula below:

=IF(OR(H10="SAT",H10="SUN",H10="OFF",H10="")," ",(SUM(K10-H10)-SUM(J10-I10)))

What I would like to adjust this to do is add if H10="HOLIDAY",
0.333333333333333 is entered (true value) (equivalent to 8 hours), if false
then complete the above checks (from above formula), if ALL false, then " "
(should be outputted).

So basically I want it to work as such: If Holiday = true, enter 8, if false
enter " ", or if Sat, Sun, Off, is true, enter " ", if false calculate
clocking times.

PLEASE HELP :)