If he is trying to calculate the time "which an agent needs to solve" an incident.. let's say this time is 36 hrs. can he just do: TimeToResolve = $TIMESTAMP$ + 129600
Marcelo -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 07, 2010 8:36 AM 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
