Thanks again Lowell. Here is my code...

SELECT INTERVALSTART

,RIGHT(INTERVALSTART, 7) as Times

,dbo.ConvToHours(Sum(ACDTIME)) as [ACD Time]

,dbo.ConvToHours(SUM(AUXINTIME+ACWINTIME)) as [Other Inb Call Time]

,dbo.ConvToHours(SUM(ACWOUTOFFTIME + AUXOUTOFFTIME)) as [Outb Ext Call Time]

,SUM(ACWOUTCALLS - ACWOUTOFFCALLS + AUXOUTCALLS - AUXOUTOFFCALLS) as [Outb Int Calls]

,dbo.ConvToHours(SUM(ACWOUTTIME - ACWOUTOFFTIME + AUXOUTTIME - AUXOUTOFFTIME)) as [Outb Int Call Time]

,SUM(ACDCALLS + AUXOUTCALLS + AUXINCALLS + ACWOUTCALLS + ACWINCALLS) as [Total Calls]

,dbo.ConvToHours(SUM(ACDTIME + AUXOUTTIME + AUXINTIME + ACWOUTTIME + ACWINTIME)) as [Total Call Time]

FROM oadb.hCmsAgent A

LEFT JOINdbo.Agent_Groups G ON A.logid = G.logid

WHERE convert(varchar(15), INTERVALSTART, 101) = '12/13/2013' --convert(varchar(15),getdate(),101)

GROUP BY A.LOGID, datepart(hh,INTERVALSTART),INTERVALSTART,ITEM_NAME,Logname

ORDER BY A.LogId, datepart(hh,INTERVALSTART)