Re: Question on Reporting Time to Resolution

[Thomas Bean]

** Hi Frank, This is a sample Crystal function that would calculate the difference between two timestamps and display in "HH:MM:SS" format:   numberVar seconds := DateDiff ("s",{HPD_HelpDesk.Assign_Time} , {HPD_HelpDesk.Resolved_Time}); numberVar hh := Truncate (seconds/3600); numberVar mm := (seconds/60) Mod 60; numberVar ss := seconds Mod 60;   ToText(hh,"00") + ":"+ ToText(mm,"00") + ":" + ToText (ss,"00"); I'm not sure how to incorporate the business time requirement into this directly in Crystal -- my suggestion would be to perform the calculation in ARS.  Add a filter that triggers when the status is set to resolved, that uses the "Application-Bus-Time-Diff" function to calculate the time to resolve and sets this value to an integer field (the return value will be in seconds).  For existing records that have already been resolved, you could run an escalation to populate the integer field.  Add this field to your Crystal report, and re-format as desired (as shown in the above function).   HTH,   Thomas   ----- Original Message ----- From: Frank Wall Newsgroups: gmane.comp.crm.arsystem.general Sent: Wednesday, July 19, 2006 11:28 Subject: Question on Reporting Time to Resolution List, I am trying to create a report in Crystal the Calculate the Time to Resolution and also just accounting for a Business Schedule of Monday to Friday, 7am to 6pm.  If any one on the list has any ideas please let me know. Thanks, Frank Wall Administrator __20060125_______________________This posting was submitted with HTML in it___