Do I Need a Macro For this?

V

Viswanathan S

Hi all!
I am trying to create a worksheet with a few formula.
Am struck here:
I have a Column A with Date in the Format (dd-mmm-yyyy)
and Column B with tine in the Format (00:00 AM/PM)..
Now I want to combine these and have one Column in Column
A (or Column C) that will have Date and Time (dd-mmm-yyyy
00:00 AM/PM)... Now these will have to be populated
automatically and only for those Rows where the A is not
NULL (ie A has some valid DATE)...

Please suggest me on this and do not hesitate to ask for
clarification on the problem if required as this is
absolute essential for my project...
Please and thanks a trillion in advance

Wishy
 
G

Guest

Hi

You can just add the date and the time together! In C2 try:
=IF(A2>0,A2+B2,"")
and then fill this down your column
 
Top