Combine date and time cells in excel

How to combine date and time cells in excel

0
1974
combine date and time cells in excel

You can easily combine date and time of two different cells in excel, all you have to do is enter the following into the formula bar:

=TEXT(date_cell,”dd/mm/yyyy “)&TEXT(time_cell,”hh:mm:ss”)

Example

Below is a worked example for how to combine a date and time cell in excel:

How to combine date and time cells in excel

=TEXT(A2,“dd/mm/yyyy “)&TEXT(B2,”hh:mm:ss”)

Tools you'll need

LEAVE A REPLY

Please enter your comment!
Please enter your name here