TIME CALCULATIONS

[Srinivas]

Sirs,

Is it possible to calculate the time difference which im importing from
different software. the data getting imported by following format. I want
to calculate how much time he have taken lunch and break. if he have taken
more than 1.30 lunch means how much time extra he have taken and break more
than 15 minutes means how much time he have taken. is there is any formula
for that

A B C D E
9195 GOPALA KRISHNA .K
ATTENDENCE 13-Oct-08 10:11:16 IN
ATTENDENCE 13-Oct-08 10:11:18 IN
ATTENDENCE 13-Oct-08 10:11:21 IN
ATTENDENCE 13-Oct-08 12:37:18 OUT
ATTENDENCE 13-Oct-08 14:10:13 IN
ATTENDENCE 13-Oct-08 19:02:25 OUT
ATTENDENCE 13-Oct-08 19:27:05 IN
ATTENDENCE 13-Oct-08 21:41:42 OUT
9197 VENKATA RAO .V
ATTENDENCE 13-Oct-08 9:58:09 IN
ATTENDENCE 13-Oct-08 10:31:38 OUT
ATTENDENCE 13-Oct-08 11:49:46 IN
ATTENDENCE 13-Oct-08 11:49:48 IN
ATTENDENCE 13-Oct-08 12:37:42 OUT
ATTENDENCE 13-Oct-08 12:37:44 OUT
ATTENDENCE 13-Oct-08 13:49:57 IN
ATTENDENCE 13-Oct-08 13:50:00 IN
ATTENDENCE 13-Oct-08 13:50:02 IN
ATTENDENCE 13-Oct-08 13:50:05 IN
ATTENDENCE 13-Oct-08 19:05:22 OUT
ATTENDENCE 13-Oct-08 19:05:24 OUT
ATTENDENCE 13-Oct-08 19:24:57 IN
ATTENDENCE 13-Oct-08 19:24:59 IN
ATTENDENCE 13-Oct-08 21:57:14 OUT

 

[Sandy Mann]

Assuming that the times are real XL times and not text, then:

=IF(AND(E4="Out",E5="In"),D5-D4,"")

and copied down will give the duration of any Out immediately followed by an
IN.

How would XL know that it was a long break and not a short lunch?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bob I]

Your data is bad, the "IN"s and "OUT"s don't match