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

Try this:

In Cell A1 =now()
In Cell B1 =TEXT(A1,"dd-mmm-yy")
In Cell C1 =TEXT(A1,"hh:mm:ss")

HTH.

"amol" wrote:

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

Hi,

If I've understood correctly try this. Copy A1 and paste it into B1.

Format A1 as date
Format B1 as time

Mike

"amol" wrote:

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

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