separating date and time from one cell to two

**bdebened** · 11-11-2009, 11:16 PM

I have a timepoint in one cell and I would like to separate the date and time into two cells so it is easier to filter. Below is an example of the data. This example would be the equivalent of 3 cells. How can I get this data to have the date in one cell and then the time next to it in a different cell? i have also attached a sample file for clarity.

11/1/2006 17:00
11/1/2006 18:00
11/1/2006 19:00

**teylyn** · 11-11-2009, 11:38 PM

For date use

=INT(A1)
format as date

for time use

=MOD(A1,1)

format as time

You could also just do

=A1 and simply format as date or time, whatever you need. When doing calculations with time values it often pays to keep the date with it, so you can cover time periods that span a date change.

hth