What is the sytanx used when calculating the avg time taken to resolve a ticket?
I have the Arrival Date /Time and Resolved Date/Time field . This is how I used but the results seems to incorrect.
Say if I have ArrivalTime(7/1/2009 5:25:15PM) and ResolvedTime (7/1/2009 7:19:58PM), the formula that I used is
(ResolvedTime - ArrivalTime) , but the calculation is wrong. I am missing something out.
Your help on this is greatly appreciated.