divide date & time into two columns

[Guest]

Hi, Can I divide a column that is displaying date time in column c to date in
d and time in e.... I imported the data from access
column c has : 04/04/2004 08:04am
and I want d to display 04/04/2004 and e to display 08:04am
thanks

 

[Frank Kabel]

Hi
D1:
=INT(C1)
and format as date

E1:
=MOD(C1,1)
or
=C1-INT(C1)
and format as time

 

[JE McGimpsey]

One way:

D1: =INT(C1)
E1: =MOD(C1,1)

format D1 as a date, E1 as a time.

 

[Bob Phillips]

If you imported it from access is text? Assuming so, try

D1: =--(LEFT(C1,FIND(" ",C1)-1))
E1: =--MID(SUBSTITUTE(SUBSTITUTE(C1,"pm"," PM"),"am"," AM"),FIND("
",C1)+1,99)

don 't forget to format the cells

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

THANK YOU THANK YOU THANK YOU

Hi
D1:
=INT(C1)
and format as date

E1:
=MOD(C1,1)
or
=C1-INT(C1)
and format as time