Converting Time Range to Date/Time in a single field
Posted on 2016-09-02
I have a spreadsheet with two rows, one with a date, and one with a time range.
CourseDate Course Time
9/7/2016 9:00 am - 9:50 am
But I need to convert it to this start date/time and end date/time like below.
Start Date/Time End Date/Time
9/7/16 9:00 AM 9/7/16 9:50 AM
Is there any way to do this automatically? I tried text to columns for the time, and then did a concatenate to put the date and time together. However, when you do that it changes the time to something like 0.375. Changing the format of the cells didn’t help either.
Thank you in advance for any suggestions!