How to combine date and time columns in Excel

If you have separate columns formatted as date and time in Excel and you'd like them combined, use a formula that converts each cell's value to a text format BEFORE combining them to make sure they keep their date/time format in the new column. You can also copy the new column and paste the values only to remove the formula dependency in additional sheets or columns. This video demonstrates this method of converting values to text before concatenating.

[vigneshadmingadmin]

Thanks bro, I saw few videos but it has not turn as I expected, but the shown formula yours is perfectly matched. I would like to thanks for giving knowledge.

[AJITHKUMAR-wute]

While applaying formula How you are selecting that date and time cells

[NaZiaCookZ]

Useful video, could you please help how to find days, hours from two timestamps

[selvarasu]

Please help us some text and time on single cell how to enter the formula

[mmgsymj]

=text(K9, "mm/dd/yyyy")&" "&text(L9, "hh:mm:ss")
Just replace the K9 and L9 with your cell IDs

[karenkehoe]

you! I tried so many ways that didnt work

[Jhonnyzilla]

way better method: =A2 + B2. Then use "long date format" or manual format "dd.mm.yyyy hh:mm" or similar for the column. Excel is able to add up dates and times.

[cliktoview]

and also how to add text in the last if we have to add