Do I Need a Macro For this?

  • Thread starter Thread starter Viswanathan S
  • Start date Start date
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
 
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
 
Back
Top