count break working

A

Andrew

Hi,
by a query I get these results:

check in check out Employee nr.
16/12/08 08.00 16/12/08 13.00 A111
16/12/08 14.00 16/12/08 18.00 A111
16/12/08 08.00 16/12/08 13.30 C123
16/12/08 15.00 16/12/08 19.00 C123
16/12/08 08.00 16/12/08 13.30 C555
16/12/08 16.00 16/12/08 18.00 C555


I'm looking for get out the break time of each employee, so:
A111= 1 hour
C123= 1.30 hour
C555= 2.30 hours

have u got any idea?
please, help me.
 
Top