I have cells which display date and time in the below format (this cannot be changed).
Thursday, November 23, 2017 04:13:00 p.m.
Friday, November 24, 2017 12:21:00 a.m.
I need to separate the time so it is in the format
04:13:00 p.m.
12:21:00 a.m.
I have tried using text to columns with fixed width but this cuts off the hours due to the difference in column widths. Have also tried using space as a delimiter but that results in the incorrect time. Is there any way I can do this?
Bookmarks