Frederick, I hope he is talking about converting the time in Hours-Minutes- Sec
Tristan If you are able to get the TotalTime then only thing you need do is convert the same in hours-min-sec frame We have the same thing in our system but he onlu difference is we calculate the pending time $PROCESS$ Application-Bus-Time-Diff This gives you the time diff Have three field which keeps time in Hours Minutes and Sec separatly. Another Field which append this and this way you get Total time in HH:MM:SS format (((($zTmpInDays$ + " days, ") + $zTmpInHour$) + " hours, ") + $zTmpInMin$) + " mins." Regards Rajesh -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 07, 2010 7:06 PM To: [email protected] Subject: Re: TimeDiff ? If I understand correctly, what you are wanting to do is to determine how long an agent had a job. Since you say you can find the beginning and end of the job all you should have to do is to subtract the beginning time from the end time. i.e. TotalTimeInSeconds = EndTime - BeginningTime Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tristan Roppel Sent: Wednesday, July 07, 2010 2:56 AM To: [email protected] Subject: TimeDiff ? Hi folks, I want to calculate the time, which an agent needs to solve it ! I can do this with $TIME$ or $TIMESTAMP$ to determinate the beginning and the end time of the agent job. But to calculate the difference between beginning and end time of this job is very complicated. I can use DATEDIFF, MONTH, YEAR, etc, etc, but afterwards i have to calculate the hours, minutes and seconds !!! Does anybody know a better solution ? I work with a very version of Remedy 5.1 ! Any help apppreciated ! Many thanks Tristan Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
