Combine Date field and Time field

I have a column with the date and a column with the time.

How can I combine these two fields into one? When I try I get the attached.
excel2.JPG
PeterErhardAsked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
If it didn't work, one of your dates / time cells is a text value masquerading as a date. You can run a text to columns to do a mass conversion or you can use this uglier version of the formula:

=if(isnumber(b1),B1,datevalue(b1))+if(isnumber(C1),C1,datevalue(C1))

Thomas
0
 
barry houdiniCommented:
Don't concatenate, sum, i.e.

=B1+C1

format in required format like dd/mm/yyyy hh:mm:ss AM/PM

regards, barry
0
 
PeterErhardAuthor Commented:
Still didn't work unfortunately.
excel1a.JPG
excel1b.JPG
0
 
PeterErhardAuthor Commented:
Thanks, that did the trick.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.