Concatenate

S

Sasha

I have one colums with dates and one column with times.
How do i concatenate them both so that my final colums
will have date + time in it?

TIA

Sasha
 
K

Ken Wright

Don't. Just add them, eg =A1+B1.

Times are stored as a portion of a day, so adding the two will give you day +
time.
 
G

Guest

thanks a lot....it's so easy...now that i see it, seems so
stupid that i hadn't thought about it earlier!!! thanks a
lot once again


sasha
 
Top