quote:

---

Basically I am looking for an accumulation of time based a set of conditions:
WBDiscoRunning = 'Running' AND CouchShtBrk = 'Clear' AND StockPumpRunning = 'Running

---

Select 
	StartTime = min(StartTime), 
	EndTime = max(StartTime), 
	TotalTimeMin = datediff(n,min(StartTime),max(StartTime))
From
	(
	Select StartTime =A.RecordDate_Time, EndTime = min(B.RecordDate_Time)
	From 
		(
		Select *
		From #tbl_1PMProduction
		Where StockPumpRunning='RUNNING'
		and CouchShtBrk='CLEAR'
		and WBDiscoRunning='RUNNING'
		) A
	Left Join
		(
		Select *
		From #tbl_1PMProduction
		Where not (StockPumpRunning='RUNNING'
		and CouchShtBrk='CLEAR'
		and WBDiscoRunning='RUNNING')
		) B
	On A.RecordDate_Time < B.RecordDate_Time
	Group By A.RecordDate_Time
	) Z
Group By EndTime
Order By StartTime, EndTime