Select [Tool Code], Sum(DateDiff(Minute, '0:00:00',[Total Down Time])) as [Total Down Time] From [dbo].[Acc_Data] Where [Bay N°] = '3' and [Reported Date] between '09/12/2014' and '09/12/2014' Group by [Tool Code] Order by [Tool Code]
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.