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