Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
calculate total time
Migrateduser
I have tickets with submit date and closed date.<br />
I wish to calculate the total time elapsed between submission and closure of the ticket.<br />
The entries in those columns are in following format:<br />
<span class='bbc_underline'><strong class='bbc'>May 10, 2013 6:15 PM</strong></span><br />
<br />
Also some tickets are not closed so there entries are blank. Also let me know how to calculate for the same.<br />
<br />
i want the elapsed time column to appear as a separate column in report.<br />
<br />
please help...<br />
and thanks in advance...
Find more posts tagged with
Comments
There are no comments yet