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

Srinivas wrote:

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