Plz help in this

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi,

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

Format A1 as date
Format B1 as time

Mike
 
If you want to separate date and time, =INT(A1) will give date, and
=MOD(A1,1) will give time. Format the cells accordingly.
 
Back
Top