SELECT COALESCE(SUM(Temp.[Second])/3600.0,0) FROM (SELECT DATEDIFF(SECOND, CASE WHEN BusinessTime.Start>Client.AddDate THEN BusinessTime.Start ELSE Client.AddDate END, CASE WHEN BusinessTime.[End]<Client.FirstContactDate THEN BusinessTime.[End] ELSE Client.FirstContactDate END) AS [Second] FROM BusinessTime WHERE BusinessTime.Start<Client.AddDate AND BusinessTime.[End]>=Client.FirstContactDate) TempThis is basically and adaption of what it is actually. But, that should give you an idea on the DateDiff() usage with Second, which is then divided by 3600. In my case, I wanted to have that in hours. So, that changed the decimal value into hours, which has decimal support with the ,0.