Hi All
Daily punching of an employee
Type Date Punch time
INPUNCH 2015-01-02 00:00:00.000 1900-01-01 10:55:40.000
OUTPUNCH 2015-01-02 00:00:00.000 1900-01-01 14:35:36.000
INPUNCH 2015-01-02 00:00:00.000 1900-01-01 15:15:10.000
OUTPUNCH 2015-01-02 00:00:00.000 1900-01-01 21:42:30.000
.
.
.
How to findout intime ie((OUTPUNCH1-INPUNCH1)+(OUTPUNCH2-INPUNCH2)..+(OUPUNCHN-INPUNCHN)
Outtime ie((INPUNCH2-OUTPUNCH1)+(INPUNCH3-OUTPUNCH2)..+(INPUNCHN-OUTPUNCHN-1)
How to findout total intime and out time ??