Split the date
Let’s start from the following document which traces the data recording every second.
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).
So, to extract the date, you can now get the full value of column A using the INT function (INT returns the integer value of a cell).
It is possible that you need to change the format of column B to display the format ‘Date‘.
Extract the time
To extract the time, simply subtract the data in column A with the entire value calculated in column B.
Again, it is possible that you have to change the format of the column C to display the cell format to ‘Time‘.