Print Page | Close Window

Converting Number to Time Value

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4099
Printed Date: 02 May 2025 at 2:16pm


Topic: Converting Number to Time Value
Posted By: pellis
Subject: Converting Number to Time Value
Date 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


Replies:
Posted By: lockwelle
Date 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


Print Page | Close Window