Time Date Formula Problem

O

Oowf

My wife and I own and operate several orphanages in China. We jus
started using a Biometric Finger Print Time Clock for our employees.
The results from the time clock are presenting quite a challenge to ge
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 Oow
 
N

N Harkawat

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

and format this cell as time
 
J

JE McGimpsey

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.
 
Top