Split the date & time in one cell to be 2 colums.
 

I want to split the date & time in one cell to be 2 colums; Date and another
colum is Time. i.e. 4/11/2006 14.30
How should I do?

Split the date & time in one cell to be 2 colums.
 

In A1: =TODAY()
format dd/mm/yyyy

in B1:
=NOW()-TODAY()
format hh:mm:ss

HTH
--
AP

"Aom" a écrit dans le message de
...
I want to split the date & time in one cell to be 2 colums; Date and
another
colum is Time. i.e. 4/11/2006 14.30
How should I do?

Split the date & time in one cell to be 2 colums.
 

If the entry is 4/11/2006 14:30 where time is 14:30 (not 14.30)...

B2:

=INT(A2)

C2:

=A2-B2

Format B2 as date and C2 as time.

Aom wrote:
I want to split the date & time in one cell to be 2 colums; Date and another
colum is Time. i.e. 4/11/2006 14.30
How should I do?

Split the date & time in one cell to be 2 colums.
 

=INT(A2)

and

=MOD(A2,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Aom" wrote in message
...
I want to split the date & time in one cell to be 2 colums; Date and
another
colum is Time. i.e. 4/11/2006 14.30
How should I do?