Combining separate Date and Time Fields

I have two different columns (for example)...

"Start Date" and "Start Time"
12/8/06 12:00 AM


I found out that i need to combine them into one column with the result being = "12/8/06 12:00 AM"

I am having trouble doing this with any of the help from excel.

Anyone know if this is possible?

Please help.

Thanks

Originally Posted by thegreenape

I have two different columns (for example)...

"Start Date" and "Start Time"
12/8/06 12:00 AM


I found out that i need to combine them into one column with the result being = "12/8/06 12:00 AM"

I am having trouble doing this with any of the help from excel.

Anyone know if this is possible?

Please help.

Thanks

Hi thegreenape,

Try this, if data in A1 & B1, then in C1

=A1+B1 , then custom format to dd/mm/yy hh:mm AM/PM

oldchippy

Or

=DATEVALUE(TEXT(A2,"dd/mm/yy"))+TIMEVALUE(TEXT(B2,"hh:mm"))

VBA Noob

I bought an excel add in which allowed me to do this.

Good for you

VBA Noob