You just need the mod function to get the fractional part of the time. Use
this

=Mod(A1,1)

Format the results in any time format you choose.

"Little Penny" wrote:

Is there a macro that can remove the time from the date. I tried
formating the cell and it remove time from the cell. However if you
select the cell the time remains.

3/20/2009 8:10:40 PM