I have a dataframe with a thousand timestamps like the following one:
I am having difficulties splitting this timestamp into two columns: Date and Time. I am not able to use the formula =INT(A2) and then =A2-B2 because the date is like this 05.03.2018. It should have been this 05/03/2018.
However, it is impossible for me to change the . to / for all the cells. It will take days to do it. If someone can help me with this?