merging 2 columns in 1

**tempmail1** · 02-02-2020, 11:31 AM

how to merge 2 columns into 1 with 1 having date in mm/dd/yyyy and the other having time in hh:mm format?

**AliGW** · 02-02-2020, 11:41 AM

Welcome to the forum.

Assuming dates in A and times in B:

=A1+B1

Excel 2016 (Windows) 32 bit

	A	B	C
1	02/02/2020	15:40	02/02/2020 15:40

Sheet: Sheet2

**tempmail1** · 02-02-2020, 11:46 AM

Thanks you AliGW for helping me solve this.

**AliGW** · 02-02-2020, 11:48 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Re: merging 2 columns in 1