Actually looking at this it doe snot pull in the date, the results pull in
01/00/1900. Any thoughts?

"Teethless mama" wrote:

=MOD(A1,1)

Format as h:mm

"Jen_T" wrote:

I have cells in a worksheet that are formatted as date but still show as date
and time. How do I pull out the time.

E.g.
04/07/2009 1:00:00 AM
I have tried the =left() and also =right () formulas with no luck.