calculate total time

S.M.

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...

Tubal

If these are date or timestamp fields, you should be able to create a data element in your table and subtract the submit date from the closed date, and then put the data element in your new column. Format the data element as the interval. (Hours or Minutes or Seconds, etc).