12 Replies Latest reply on May 11, 2011 11:41 AM by xxx202xxx

    Elapsed Time Calculation Needed Between two Date fields.

    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.