Plz help in this

A

amol

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
 
Q

Qull666

Try this:

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

HTH.
 
M

Mike H

Hi,

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

Format A1 as date
Format B1 as time

Mike
 
D

David Biddulph

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