T
Tara Martin
I have entered the formula
=IF((OR(E35="",C35="")),0,IF((E35<C35),((E35-C35)*24)+24,(E35-C35)*24))+IF((OR(I35="",F35="")),0,IF((I35<F35),((I35-F35)*24)+24,(I35-F35)*24)),
but I cannot figure out how to show my cell blank if there is no information
in it....Please help
=IF((OR(E35="",C35="")),0,IF((E35<C35),((E35-C35)*24)+24,(E35-C35)*24))+IF((OR(I35="",F35="")),0,IF((I35<F35),((I35-F35)*24)+24,(I35-F35)*24)),
but I cannot figure out how to show my cell blank if there is no information
in it....Please help