Date and Time Concatenate Help

Originally Posted by Mr Gow

Column A has date data formatted yyyy/mm/dd. Column B has time data formatted hh:mm:ss. I would like a formula to return in Column C "yyyymmddhhmmss" without any colons or slashes etc

Hi,

the site http://www.cpearson.com/excel/datetime.htm#SerialDates shows some information on Dates and Times, but for your question, the Custom Format yyyymmddhhmmss with the formula =INT(A1)+MOD(B1,1)
should suffice.

hth
---

try this

=YEAR(A6)&IF(MONTH(A6)<10,0&MONTH(A6),MONTH(A6))&IF(DAY(A6)<10,0&DAY(A6),DAY(A6))&IF(HOUR(B6)<10,0&HOUR(B6),HOUR(B6))&IF(MINUTE(B6)<10,0&MINUTE(B6),MINUTE(B6))&IF(SECOND(B6)<10,0&SECOND(B6),SECOND(B6))