Concatenating Dates and Times in Excel 97 2

[prajac]

I have a date in one cell dd/mm/yyyy and a time in another adjacenct cell hh:mm and I am trying to concatenate the two so I have "dd/mm/yyyy hh:mm". I have tried to use the concatenate formula and various others to no avail. Does anyone know how to do this?

 

[LSTAN]

Hi

try this,

=CONCATENATE(TEXT(A1,"dd/mm/yyyy&quot,":",TEXT(B1,"hh:mm&quot)

Hope this is what you want.

Regards
LSTAN

 

[JGillespie]

Just add them up!!

if cell A1 contains a date and cell B1 contains a time (both formatted to display correctly) then putting the following formula in a cell will give you the correct result:

=A1+B1


Simple isn't it!

HTH Jamie Gillespie
j-gillespie@s-cheshire.ac.uk

 

[Rhort]

Spot on, Jamie. That's the simplest way; I'd have done it like that. I avoid CONCATERNATE formulae wherever possible; I find they're just TOO complicated for their own good!