Elapsed Time Calculation Needed Between two Date fields.
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.