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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting just the time portion 6
separating date and time 5
Checking for date and time overlaps 0
Need help with converting CUSTOM format/TEXT format to DATE format 6
Date conversion doesn't make sense 3
Counting Occurrence of a Value within Cells 1
HELP! I need to make an IF Statement comparing date/time fields.. 2
date and time difference 19

Top