Format cells problem with separating Date and Time

in Cell A1, is a field containing Date and Time. I want to be able to separate the date and time and display in another cell. I used the functions Left and Right to separate them and then format the cells to display it in date and time format individually

Cell C1=40350 is the numerical value of the date 21/06/2010
Cell C2=.375 is the numerical value of the time 09:00

However I cannot apply format cells on these cells to get it to display data and time.

You can:

=A1 formated as date and in other cell formated as time

or this

=INT(A1) formated as date
=A1-INT(A1) OR =MOD(A1;INT(A1)) formated as time