Date and time format decimals

[junada0]

I have tried several methods of formatting but am stuck with the enclosed sample data.

In col D I have some sample date data (12/02/2015 07:49:00) that is in an export file that I have received, if I copy the data to Col E (paste value) I get a decimal date like this (42047.3256944444) which incidentally looks like 42047.32569 in the cell E7.

I would like to see the date and the time in two separate columns as shown in Green, any help appreciated.

G

[gmr4evr1]

Here is one way to do it, with a simple formula and formatting...
Date and Time.xlsx

[junada0]

Hi Tom,

Many thanks, looks ok at first glance and sorry if I did not expand but if I copy the columns with formulas and paste (values) I still see the full string of date and time which then causes an issue when I try to filter the column (I just want to see the date in the filter and no time) , which was my next stage ( sorry I did not make this clear).

Would appreciate any expansion on this.

G

[gmr4evr1]

Which column would you like to see the date in, and which column would you like to see the time in? In F and G, or E and F? I set it up for columns F and G. I attached another copy because I forgot to format column E on the first one.
Date and Time.xlsx

[azumi]

Please see this hope this works

[junada0]

Many thanks.

The INT formula does the job and allows the filter to work correctly, appreciate all your help.

Just found this also . "A Date-Time serial number, with General formatting, shows up as an Integer.Fraction"

C