J
Jan
Thanks to Bob Phillips for the following formul
=SUMPRODUCT((C$1>=TIME(ROW(C6)-6,0,0))*(C$1<TIME(ROW(C6)-5,0,0)))*C$
it is not working quite right yet
This is what I hav
Start C1=00:00 (entered
Stop C2=5:00 (entered
Duration C2-C1 (Calculated
Items per Hour C4 (Entered
Total Production Production Total C
B6:B29 1-24 (Hours in day
C6:C29 formula=SUMPRODUCT((C$1>=TIME(ROW(C6)-6,0,0))*(C$1<TIME(ROW(C6)-5,0,0)))*C$4 (Copied down the column
I would expect there to be 100 in C6:C10 but Im only getting it in C6. Also if start time is anything but even hour, it still gives full production for the hour. Any ideas suggestions
Thanks again!
=SUMPRODUCT((C$1>=TIME(ROW(C6)-6,0,0))*(C$1<TIME(ROW(C6)-5,0,0)))*C$
it is not working quite right yet
This is what I hav
Start C1=00:00 (entered
Stop C2=5:00 (entered
Duration C2-C1 (Calculated
Items per Hour C4 (Entered
Total Production Production Total C
B6:B29 1-24 (Hours in day
C6:C29 formula=SUMPRODUCT((C$1>=TIME(ROW(C6)-6,0,0))*(C$1<TIME(ROW(C6)-5,0,0)))*C$4 (Copied down the column
I would expect there to be 100 in C6:C10 but Im only getting it in C6. Also if start time is anything but even hour, it still gives full production for the hour. Any ideas suggestions
Thanks again!