how to calculate Average Time Duration

• suresh0534

  SSCommitted

  Points: 1966

  More actions

  October 25, 2013 at 3:30 pm

  #285239

  Hi,

  I am counting values from database like

  Total Calls Made:0:53:29 , Total Calls Received:0:11:25 , Total Call Duration:1:4:54

  Total Calls Made:43 , Total Calls Received:5 , Total Call Duration:1:4:54

  here how to calculate Average Time Duration:

  Total Time Duration / (Total Calls Made + Total Calls Received)

  (1995 +20214) / (43+5 )

  How can we calculate the Average time(In hrs:mm:ss)

  How can we calculate the Average time.

  Thanks

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  October 25, 2013 at 4:20 pm

  #1661759

  Your formula seems correct but you don't have number or calls made or received, instead you have duration of them. Check your data and post again.:-)

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• fahey.jonathan

  Hall of Fame

  Points: 3617

  More actions

  December 12, 2013 at 5:33 pm

  #1673134

  To calculate "average duration", convert the duration for each record to milliseconds, then average the number of milliseconds for the group. Once you have that, then add that to a "zero" date and format it as time. In this example, the average milliseconds is the "12345" value:

  SELECT CONVERT(VARCHAR(12), DATEADD(MILLISECOND, 12345, 0), 14) AS Duration

  Duration

  ------------

  00:00:12:347