Insert a column to the right of the column you want to split.

Highlight the column to split using the text to columns icon on the Data menu.

Delimited, in “Other” type T, click Finish. It will state there is "already data here", this is because the new column has Column 1.

If you don’t require the time, delete this column.

Highlight column, right hand click, Format Cells.