i responded to barry's post at http://www.mrexcel.com/forum/excel-q...ml#post3640053

i am not certain of the existing formula myself as i have inherited it just that the basic requirement is to count the time that it takes for the status to flip for those listed in the example.

I will review BobBridges proposal and update further