I got it! I was doing the set the fields all at the same time. I set the 1st action to set field for the Total Que Time then another action to set the fields of the rest. Thanks for your help! It works now
Rocky - wrote: > > 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-tp15950817p15976737.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"
