Viewing post 1 (of 1 total)
Try that, for the previous #CallCost table
select aGroup, sum(datediff(ss, '00:00:00', aTime)) totalSecs,
sum(datediff(ss, '00:00:00', aTime)) / 3600 as hrs,
(sum(datediff(ss, '00:00:00', aTime)) / 60) % 60 as mins, -- %...
July 6, 2008 at 12:31 am
#838574