Hit send by mistake...


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)5/24)+((B3+C3)1/3)))


In article ,
JE McGimpsey wrote:

Not sure why you need a macro. A worksheet function works fine:


=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*((B3+C3)5/24)