t

[Cricket2]

=ROUND(IF((OR(C9="",D9="")),0,IF((D9<C9),((D9-C9)*24)+24,(D9-C9)*24))+IF((OR(E9="",F9="")),0,IF((F9<E9),((F9-E9)*24)+24,(F9-E9)*24)),2)

 

[Cricket2]

Test 1<font color="f1f1f1">Test2</font>





<font color="ffebd7">Test3</font>

Test 4


antiquewhite

Burlywood

 

[Cricket2]

Test 1<font color="f1f1f1">Test2</font>





<font color="ffebd7">Test3</font>

Test 4


antiquewhite

Burlywood