If you want to separate date and time, =INT(A1) will give date, and
=MOD(A1,1) will give time. Format the cells accordingly.
--
David Biddulph

"amol" wrote in message
...
how i want is
i my excel cell say A1 has date and time together but i need the differece
of date and time seprately or furter how can i seperate the date and time
from one cell int o two different cells