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