Concatenate Date and Time Fields

[CorrieAnn]

I have date and time columns (start date/start time and end date/end time) that I am manually concatenating (typing) so that I can calculate a duration. I would like to be able to have a formula do this for me, but a standard concatenate doesn't work. How can I achieve this?

START DATE	START TIME	CONCATENATE VALUE	END DATE	END TIME	CONCATENATED VALUE	ELAPSED TIME (WORKING HOURS)
1/17/2020	10:04 AM	1/17/2020 10:04 AM	1/23/2020	4:00 PM	1/23/2020 4:00 PM	50:56

 

[Fluff]

If your dates & times are real dates/times, rather than text, use
=A2+B2

 

[CorrieAnn]

They are, and I did. So thankful for the simple solution. Thanks!

 

[Fluff]

You're welcome & thanks for the feedback