Nothing received here yet!

--
---
HTH

Bob


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



"Bob Phillips" wrote in message
...
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?