Creating a separate form is the right idea. Put two date/time fields on it--call them what you want...maybe Time in Queue and Time Out of Queue or something similar. Create two filters--one that sets the "in" time and one that sets the "out" time. The one that does that "out" time can also do the calculations I describe below.
Have a third field on your form capture the difference between "in" time and "out" time, and that's simply "out" - "in". That will give you a number of seconds, so that field should be an integer field. Let's call that field Total Queue Time. Now we need to convert the total number of seconds to the corresponding days/hours/mins format. Throw three more integer fields onto your form. Let's call them Queue Time Hours, Queue Time Minutes, and Queue Time Seconds. You'll use these to calculate the time part of the desired days/hours/mins format. Set them with these values: Queue Time Days = TRUNC($Total Queue Time$ / 86400) Queue Time Hours = TRUNC((($Total Queue Time$ / 86400) - $Queue Time Days$) * 24) Queue Time Minutes = (((($Total Queue Time$ / 86400) - $Queue Time Days$) * 24) - $Queue Time Hours$) * 60 OK, so now you have a field holding your days, a field holding your hours, and a field holding your minutes. All you need to do now is concatenate them into a character field by doing some string functions: (((LPAD($Queue Time Days$, 2, "00") + "/") + LPAD($Queue Time Hours$, 2, "00")) + "/") + LPAD($Queue Time Minutes$, 2, "00") In the above I'm doing a series of LPAD functions so the system will fill in a zero if the value is less than ten. For example, 1 day, 1 hour, and 1 second would be: 01/01/01. HTH, Norm -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rocky - Sent: Monday, March 10, 2008 10:29 AM To: [email protected] Subject: Track time on how long the ticket was on a group's queue Please help... This is for a custom application and I need to be able to track how long the ticket is sitting on a groups queue in days:hours:mins before it gets re-assigned or resolved. I tried creating a new form that supposedly will track the assigned time and reassigned time and I just can't get it to work. Thanks, Rocky -- View this message in context: http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%2 7s-queue-tp15950817p15950817.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
