Concatenate

  • Thread starter Thread starter Sasha
  • Start date Start date
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
 
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.
 
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
 

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

CONCATENATE error? 4
Using the concatenate function 3
finds and concatenate 20
Excel Formulas Help 1
CONCATENATE Question 4
Help for the formula 9
Excel Jululian 2
Date calculations 5

Back
Top