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
 SSC Rookie Group: General Forum Members Last Login: Wednesday, March 05, 2014 8:50 AM Points: 43, Visits: 229
 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 Group: General Forum Members Last Login: Today @ 2:24 PM Points: 2,534, Visits: 5,370
 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.I am a great believer in luck, and I find the harder I work the more I have of it. Stephen LeacockForum Etiquette: How to post data/code on a forum to get the best help
Post #1508620
 Posted Thursday, December 12, 2013 5:33 PM
 SSC-Enthusiastic Group: General Forum Members Last Login: Monday, December 30, 2013 2:03 PM Points: 106, Visits: 354
 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