One way:

=MOD(A1,1)

Format as Time

--
Biff
Microsoft Excel MVP


"Jode" wrote in message
...
I have a speadsheet and one of the cells has the date and time. I want to
know can you pull the time part of this cell and imput into another
cell???