Skip to Content
0
Former Member
Nov 25, 2009 at 09:50 AM

DateTime converting into hrs

15 Views

Hi.

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.

Thanks

Cauvery