Thread: sum if
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Franz Franz is offline
external usenet poster
  
Posts: 10
Default sum if
"choice" ha scritto nel messaggio


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.


Maybe, you could reorganize your data table in this way:

A B C D
E
1 date ID# CLOCK IN CLOCK OUT WORKED HOURS
2 04/23/05 1331 10:00 19:00 =D2-C2
3 04/23/05 1976 12:00 19:00 =D3-C3


--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------


Reply With QuoteReply With Quote