I'm working with a Cisco Call Center table and I am trying to determine the Average Speed to Answer (CallWaitTime/Calls Answered).  These fields are both given as a time value (00:06:36).  When I divide this by the number of calls (say 2 calls), the Cisco lists the SAS as 3:18.  I'm trying to pull data directly from the database and get results that match Cisco's.  When I take 00:06:36 and multiply 6 * 60(seconds)=360 +36=396 and divide that by 60 and get 6.6/2(number of calls)=3.3.   Cisco shows this in their report as 00:03:18.  I can't figure the formula for the ASA and converting numbers into a time value.  Any help will be greatly appreciated.

 

Thanks

 

Pellis