I need a query that will give me avg call durations on a per/day.
I have a query that will give the call times but not sure how to get it to get the rest of the way.
Thanks
John Fuhrman
I have a query that will give the call times but not sure how to get it to get the rest of the way.
SQL:
select
--s.seconds / 3600 hrs,
--s.seconds / 60 - (seconds / 3600 ) * 60 mins,
--s.seconds - (s.seconds / 60) * 60 seconds,
cast(s.seconds / 3600 as varchar) + ':' +
cast((s.seconds / 60 - (seconds / 3600 ) * 60) as varchar) + ':' +
cast((s.seconds - (s.seconds / 60) * 60) as varchar) ElapsedTime
from (select datediff(second, [Start Time & Date], SEIPrint) as seconds From dbo.Activity
Where ([Start Time & Date] BETWEEN '2013-06-1' AND '2013-06-7')
AND SEIPrint Is Not Null) s
Thanks
John Fuhrman