Hi,

I am trying to create a formula that can automatically add the time to the date in column A. I have the right custom number category at it works if I copy and paste it, I just have 200 plus to do so I need a formula to do it.

Column A Column B

01/01/10 09:34:00
02/01/10 10:24:00
03/01/10 11:00:00

I have tried and failed many A2+B2 type formaulas but am completely confuddled.

Any help would be greatly appreciated

Thankyou Ben