Concatenate two columns keeping date and time formatting

[nailuss999]

Hi guys!
I have a column A that refers to dates in the custom format: "mm/dd/yyyy" and a column B that refers to times in the custom format: "hh:mm:ss". Well, I need to concatenate both columns and create a column C but keep the format of the previous ones.

Example: Column A: 01/25/2022 Column B: 08:45:00 Column C should read: 01/25/2022 08:45:00

I can't manage to concatenate them and get them in the right format, neither giving them a custom format like "mm/dd/yyyy hh:mm:ss".

Does anyone know how to solve this?

Thanks in advance colleagues!

Translated with www.DeepL.com/Translator (free version)

 

[Fluff]

Just add the cells together with =A2+B2 & format the cell to show date & time.

 

[Coyotex3]

Maybe something like this:

=CONCAT(TEXT(A1,"mm/dd/yyyy")," ",TEXT(B1,"hh:mm:ss"))

 

[Joe4]

Welcome to the Board!

Excel really stores dates as numbers, specifically the number of days since 1/0/1900 and time is just the fractional component of one day.

So, if your entries are true date and time entries (and not text), you can simply add the two values together, and just use apply a format of "mm/dd/yyyy hh:mm:ss" to the cell to get what you want.

EDIT: Just note the difference in replies and potential implications. The solutions Fluff and I posted will return valid date/time entries. Coyotex3's reply will return a Text value.
If you are trying to perform any sort of mathematical computation (or sorting) on the result, you will want valid/date time entry.
If it is for display purposes only, the method returning text would be fine.

 

[nailuss999]

Thank you very much for the prompt response friends! Solved!

 

[Fluff]

Glad we could help & thanks for the feedback.