extracting time only

[Michel Khennafi]

good morning

I have a seri of cells where the information inside is like

10/2/2007 4:38:00 PM

I would like to create 2 columns where in one of them I have the date only
and in the other I have the time only

Any idea as to what is the best thing to ddo?

Help is appreciated ... Thanks

 

[Pete_UK]

You can get the date with:

=INT(A1)

and the time with:

=MOD(A1,1)

if your date/time is in A1.

Format the cells appropriately.

Hope this helps.

Pete