so you can convert the text to total minutes to add it up
//totalminutes as
tonumber(left(timefield,2))*60 + tonumber(right(timefield,2))
sum this field aat the call id group level
SUM(@totalminutes,table.callid)
gives you the total minutes for the call
assuming it does not go over 24 hours you can convert it into your format
as
dateadd('n',SUM(@totalminutes,table.callid),datetime(1900,1,1,0,0,0)) and then format this as military time HH:MM only
Edited by DBlank - 28 Jun 2011 at 11:57am