Hi all,

I have the following date format in one cell (examples):
Dec 28 2017 11:01AM
Jan 3 2018 2:25PM
Mar 2 2017 12:12PM

As you can see, they vary in text length so I can't use left, right or mid, at least I think I can't

I need to extract the date and time from those cells. After I extract it, I then need to find the difference between the times to the second. In my example, the difference for example from Dec 28 2017 11:01AM to Jan 3 2018 2:25PM in seconds which I would then convert to days, hours, minutes and seconds. Please help.