C
Cold1
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
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