sum if
=(SUMPRODUCT(--(B1:B100=1976),(--(D1:D100="OUT")),E1:E100)-SUMPRODUCT(--(B1:
B100=1976),(--(D1:D100="IN")),E1:E100))*24
--
HTH
Bob Phillips
"choice" wrote in message
...
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
|