Say your data is in cell A1
then use this
=A1-INT(A1)

and format this cell as time

"Oowf" wrote in message
...

My wife and I own and operate several orphanages in China. We just
started using a Biometric Finger Print Time Clock for our employees.
The results from the time clock are presenting quite a challenge to get
the employees hours for each day.

The first thing I need to do is find out how to extract the (time only)
from a date/time cell that looks like this. 5/14/2005 6:52

Thank You!

Cheers!

The Oowf


--
Oowf