AnsweredAssumed Answered

Elapsed Time Calculation Needed Between two Date fields.

Question asked by xxx202xxx on Mar 10, 2010
Latest reply on May 11, 2011 by xxx202xxx

Title

Elapsed Time Calculation Needed Between two Date fields.

Post

I have looked all over and was not able to locate the calculation that I think I need.  Let me say I don't think I am smart enough to apply what I've read to my situation.  With that said here is my problem.

 

I have just created a Trouble Ticket which automatically populates a field called "opened" with a timestamp. 

I have another field called "closed" that auto-populates a timestamp once the ticket is closed.   

I want my third field called "elapsed" to calculate and display the amount of time (in days) that the ticket is open. 

 

Once the ticket is closed I want the "elapsed" field to stop calculating.

Outcomes