Time Date Formula Problem
 

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

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

One way:

=MOD(A1,1)

However, if you're trying to get the employee hours, you don't need just
the time. Subtracting the clock-out time from the clock-in time gives
you an XL time:

A1: 5/14/2005 6:52
A2: 5/14/2005 15:01

A3: =A2-A1 === 8:09

when A3 is formatted as a time.

Keeping the dates will help immensely for your overnight shifts, since
the times "roll over" at midnight.

In article ,
Oowf wrote:

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