<"Hit send by mistake..."
Did you mean that literally John?
Do you have something on your keyboard that is "hittable?", that can
initiate a "send"?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"JE McGimpsey" wrote in message
...
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)