Time Spent HTML and Query Problems - Need Urgent Assitance
I am trying to produce a custom report in a tabular format with the following headers: Ticket ID #, Requester, Technician, Created Date, Completed Date and Time Spent (Completed Date - Created Date).
However, when choosing the Created and Completed Date this is what I get:
Request ID Requester Technician Created Time Completed Time
3 David Brooks Rose Washak 1156263888921 1156271163156
4 David Brooks Rose Washak 1156266718140 1156269141812
Also the Request ID is not the ticket ID # it is a new created ID #. And I can't get to write the right code to get the time spent which should be completed date minus created date. Could you please help me with this?
Thanks.