Hi all,
I am trying to analyse phone call durations for call center data but although I can get the relevant parts of the time stamps using datediff, I can't think of a good way to add up all the hours, minutes, seconds, hence if I have 120 seconds then that would
become 2 mintues and I would add that to the minute column and hence the same thing with minute, when I get to 60 minutes that becomes an hour to be added to the hour column.
The code that I am using is :-
DATEDIFF(hour,callstarttime,
callendtime)
as
hours,
DATEDIFF
(minute,callstarttime,
callendtime)
as
minutess,
DATEDIFF(second,callstarttime,
callendtime)
as
seconds
which gets me a line per call with hours/minutes/seconds but I need to add them all up across all the lines that I am looking at, if that makes sense.
If anyone can help it would be much appreciated.
Thanks Phil
View Complete Post