Hello,

I am having difficulty trying to come up with syntax that will produce what I need. I need to calculate activity hours between dates when clients can participate in more than one activity in a given time period.

The results I need using the data below are:

Client 1 participated for 80 hours from 9/1/06 to 9/21/06 and for 10 hours 9/25/06 to 9/30/06.

Client 2 participated for 50 hours from 9/1/06 and 9/14/06.

Client 3 participated for 80 hours from 9/1/06 and 9/30/06...and so on.

Here is the data:

DATA LIST /ID 1 ACT1ST 3-10 (ADATE) ACT1END 12-19 (ADATE) ACT1HRS 21-22 ACT2ST 24-31 (ADATE) ACT2END 33-40 (ADATE) ACT2HRS 42-43 ACT3ST 45-52 (ADATE) ACT3END 54-61 (ADATE) ACT3HRS 63-64. BEGIN DATA 1 09/01/06 09/14/06 40 09/07/06 09/21/06 40 09/25/06 09/30/06 10 2 09/01/06 09/14/06 40 09/05/06 09/12/06 10 3 09/01/06 09/08/06 20 09/09/06 09/30/06 60 4 09/01/06 09/05/06 20 09/21/06 09/30/06 60 5 09/18/06 09/30/06 90 END DATA.

Please note that clients can have between 1 and 9 activities in a given month and activities can be performed concurrently.

I would appreciate any help I can get.

Thank you, Craig Kahklen