Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 how to calculate Average Time Duration Rate Topic Display Mode Topic Options
Author
 Message
 Posted Friday, October 25, 2013 3:30 PM
 Valued Member Group: General Forum Members Last Login: Saturday, February 13, 2016 6:29 PM Points: 63, Visits: 344
 Hi,I am counting values from database likeTotal Calls Made:0:53:29 , Total Calls Received:0:11:25 , Total Call Duration:1:4:54Total Calls Made:43 , Total Calls Received:5 , Total Call Duration:1:4:54here 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
Post #1508615
 Posted Friday, October 25, 2013 4:20 PM
 SSCrazy Eights Group: General Forum Members Last Login: Yesterday @ 8:17 PM Points: 8,218, Visits: 17,782
 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
Post #1508620
 Posted Thursday, December 12, 2013 5:33 PM
 SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, August 11, 2016 3:37 PM Points: 108, Visits: 392
 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 DurationDuration------------00:00:12:347`
Post #1522537

 Permissions