I followed your instructions and I was able to get the value of the Total Queue Time but the Que Time Minutes always gets a value of "0" and the Character field for days/hours/mins gets 00/00/00. I don't know what I'm missing.
I set the values exactly as you did: 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 Thanks for your help! Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > > 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: > > > 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" > > -- View this message in context: http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%27s-queue-tp15950817p15976700.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"
