I am putting together a time card for my work. I have figured out how to
figure the times, but if "holiday" is put into the time slot I need "8" to go
into the hours cell automaticly. Here is my current time sheet.

=IF((OR(D11="",C11="")),0,IF((D11<C11),((D11-C11)*24)+24,(D11-C11)*24))

I need to place 8 in cell J21.

Any help would be greatly appreciated.

Thank you,

Craig Old