How to concatenate date and time values together in Microsoft Excel? MS Excel Tutorial #23

Concatenate function in Microsoft Excel is very powerful. In this excel Tutorial, we will learn the process of concatenating date and time values together.

How to concatenate date and time values together? Come, let's learn Excel better.

Want to get skilled at something ?
Being Skilled helps you become skilled by watching 5 minute video tutorials and learning at your own pace.

[farihashahid]

next time plz zoom in the screen a bit so we don't have to strain our eyes

[obed_m]

Thanks for saving me, my project owes you.

[umbnmbu]

what if we want to add two cells (A1, A2), each containing 00:45, so I want to concatenate( "Time in minutes is", " ", A1+A2) it is giving a weird number...what is the correct formula here?

[gurubasugurupadagol]

Thanks brother
. It helped me a lot :)

[nestoriorubio]

yes sir a very big help thank you very much

[Anonymous-kgyg]

hey can you make a tutorial where I want to merge all dates in one cell data please