TimeSpent in New Custom Report - differs from Close-Open time difference

TimeSpent in New Custom Report - differs from Close-Open time difference

Hi there

I would like to see the time spent on request, and  luckily I found TimeSpent custom report
I have selected 'Time Elapsed', 'Created Time', ' COMPLETEDTIME   ', 'Resolved time'.
As a result I get the query
SELECT wo.WORKORDERID "Request ID",wo.TIMESPENTONREQ "Time Elapsed",wo.CREATEDTIME "Created Time",wo.COMPLETEDTIME "Completed Time",wo.RESOLVEDTIME "Resolved Time" FROM WorkOrder wo WHERE (wo.ISPARENT='1')

I would expect that  wo.TIMESPENTONREQ "Time Elapsed"  is the difference between closing and opening the request, but it is not always like that
My question is: What is exactly  wo.TIMESPENTONREQ "Time Elapsed"?
What is the best to use as a measurement of how long time does it take to solve an issue?

I have attached snapshot of the report. On the red line - Time Elapsed is 00:45:21, but the difference is 154:26:00. And there are many like that


Thanks,
Tzvetan
              New to ADManager Plus?

                New to ADSelfService Plus?