Down to the integer
=ROUNDDOWN(IF(OR(B3="",B4=""),0,IF(B4<B3,(B4-B3)*24+24,(B4-B30)*24)),0)
--
HTH
Bob Phillips
"HP" wrote in message
...
How do I add the round down function to the formula below?
IF((OR(B3="",B4="")),0,IF((B4<B3),((B4-B3)*24)+24,(B4-B30)*24))
|