"Bob Phillips" wrote in
:

This will give decimal hours

=(TIME(INT(B2),MOD(B2,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0)+TIME(INT(
D2),M OD(D2,1)*100,0)-TIME(INT(C2),MOD(C2,1)*100,0))*24


Will the formula allow me to input in decimal form