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|