04/23/05 1331 CLOCK IN 10:00
04/23/05 5070 CLOCK IN 11:00
04/23/05 1976 CLOCK IN 12:00
04/23/05 1976 CLOCK OUT 19:00
04/23/05 1331 CLOCK OUT 19:00
04/23/05 5070 CLOCK OUT 20:00

this table is added to every day,
basically i need to find out how many hours each employee worked each day
im thinking i need a triple sum if? if this date, this employee, if clock out
and subtract that from if this date, this employee, if clock in.

thanks in advance