Hmm, very nearly, but no I don't think that would always be the case.

The data I'm working with is a snapshot of all tasks completed between Jan and I think October. The data is then displayed by reference number with the first recorded task starting things off. In that circumstance it might mean that somewhere within the data a case doesn't start with a TASKCOMP.

I would also need to measure the time taken between other task stages, so these would not always end with a TASKCOMP either. My limited knowledge of these things suggests that column E is the driver, so I would want to select one type of audit note to start and then another to end.

For example on Line 37, we start with a NEWCASE but end on Line 46 with ONHOLD as there are a couple of extra tasks carried out.

Hope this makes sense.

Ballst