Vba to combine date and time

[Eean]

Hi,
I think there's an easy answer to this one but I can't work it out.
I have a range of data where A2 = a date in (dd/mm/yy) and B2 has the time in (hh:mm:ss).
What's the best way to take the times from Column B and add them to Column A's data in (dd/mm/yy hh:mm:ss)
Thanks in advance,

Ian.

 

[MisterBates]

Excel stores dates/times as numbers where the integer part is the date and the fractional part is the time. To combine the two columns, use =int(a2) + (b2 - int(b2)).

 

[Peter_SSs]

If A2 is just a date and B2 is just a time, then you should be able to add them directly:
=A2+B2

It may be that you need to format the resulting column as dd/mm/yy hh:mm:ss

 

[Eean]

When I use that formula:

A1 = 11/6/2013

B1= 23:16:15

G1(formula cell) is showing as 6/12/2013 08:28:43?

 

[Peter_SSs]

I missed the title information that you were looking for vba.
If that is still required, tell us more about how much data you have, where is is, and where the result(s) should go.

 

[Eean]

If A2 is just a date and B2 is just a time, then you should be able to add them directly:
=A2+B2

It may be that you need to format the resulting column as dd/mm/yy hh:mm:ss

I think this will work for me, It's only a fraction of the data that I need to compile that has been collated in a different format.
Thanks so much!
Ian.