Yes sure

send it to

bob dot phillips at tiscali dot co dot uk

do the obvious with it

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Linda" wrote in message
...
I tried it but it still does not work correctly. Is there anyway I can
send
u a copy of the worksheet? It really is a simple spreadsheet. Maybe I'm
asking for more than Excel can be perform.

"Bob Phillips" wrote:

Linda,

Use this

=SUMPRODUCT(--(OFFSET($B$2,0,0,COUNTA($A:$A)-1,1)=M$1),(OFFSET($D$2,0,0,COUNTA($A:$A)-1,1)-OFFSET($C$2,0,0,COUNTA($A:$A)-1,1)))*24*4

You can then add more rows without changing the formula.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Linda" wrote in message
...
I'm back. The formula worked great for the first 4 rows that you wrote
the
formula for. But when I added new numbers (1,2, or 3 thru 8) to the
activity
column and the times in the begin and end and tried to expand the array
to
include the new numbers and times, I received "0:00 or ##. Any
suggestions?