Plz help in this
 

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

Plz help in this
 

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

Plz help in this
 

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

Plz help in this
 

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