Excel combine date and time - Gaintoearn

 How to combine Date and Time in Excel 

Combining date and time into two different ways in excel. Both methods very useful to work smart.

Method 1

Below has given date and time that we need to combine into one cell

Step 1 :  Simple formula using how to combine date and time in Excel

Step 2 :  A2 indicates Date column and B2 indicates Time column

Step : 3  Type below formula in C2 column

            Combine Date & Time Formula 1  = SUM(A2,B2)

Step : 4 Now you will get combine date and time in excel 

Method 2

Apply below formula in C2 Cell then track

Combine Date & Time Formula 2   =TEXT(A2,"dd-mm-yy ")&TEXT(B2,"hh:mm:ss")

Above two method you can use to combine date and time.

Gaintoearn always focus to give short and sweet answer and easy to understand all 👍.