Split the date

Date_Split_Time_1Let’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).

Date_Split_Time_2So, 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).

= INT (A2)


It is possible that you need to change the format of column B to display the format ‘Date‘.


Extract the time

Date_Split_Time_3To 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‘.