Split the date
We want to split the date and time in order to put the date in column B and time in column C.
To accomplish this separation, we must keep in mind that the value of 1 represents 1 day. Time is a fraction of a day, for example, 0.33333 is 8 hours (1 / 3 of a day).
It is possible that you need to change the format of column B to display the format ‘Date‘.
Extract the time
Again, it is possible that you have to change the format of the column C to display the cell format to ‘Time‘
Practice within the file below (Double-clic in the cells to visualize the formulas)