Try this:
Select UserName, Hrs=(Sum(AcctSessionTime)/3600)
From Calls
Group By UserName
HAVING Sum(AcctSessionTime) > 1800
Order By UserName
Compute Avg((Sum(AcctSessionTime)/3600))
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com