Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Converting Number to Time Value Post Reply Post New Topic
Author Message
pellis
Newbie
Newbie


Joined: 09 Mar 2008
Online Status: Offline
Posts: 14
Quote pellis Replybullet Topic: Converting Number to Time Value
    Posted: 27 Aug 2008 at 12:20pm
Hello,
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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 28 Aug 2008 at 6:12am

3.3 minutes is 3 minutes 18 seconds.  Multiply the decimal (3) by 6...each tenth of a minute is 6 minutes (60/10).  Hope this helps

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.046 seconds.