You need two additional fields, one for the Close date & a calculation field.
Calculation would be Close Date - Open Date
Hope this helps
Sorry forgot to mention, there are two ways to fill the close date, one is to manually type the date or two create a script & attach to a button that sets the close date to current date.
Thank you. This is what I thought, but I guess it looked too easy. But I do have one question, when the time is calculates, I am forced to click on the field before the time is formatted correctly. For instance, if a ticket is open for an 51 minutes, it initally shows up in the age field as 12:51:51, but when I click on the field, it shows correctly as 00:51 minutes. How can I get it to show up correctly? I did all the formating tricks, I even tried changing the calculation format to timestamp, which works, but I don't need the date part.
This sounds to me like you have two fields for the opening - date and time. If so, I would be using a single timestamp field that contains both date and time. Similarly, have a single timestamp field for the closing date and time.
To enter the opening timestamp, you would either use an auto-entered timestamp (on record creation) or use a button that inserted the current timestamp ( Get ( CurrentTimeStamp ) ). To enter the closing timestamp, use a button.
To calculate the age of the ticket, create a calculation field with a time result:
CloseTimestamp - OpenTimestamp
Take careful note of the result type for the calculation - it must be a time.
Now if I change my current date and time fields to one timestamp field, I will lose all previous data?
Yes you will.
What you can do is to create a new timestamp field called OpenTimestamp, and place it on the layout.
Show all records.
Click in the new timestamp field and choose Records > Replace Field Contents…
Click the radio button for "Replace with calculated result"
Enter the expression: Timestamp ( Opendate ; Opentime ) // use your own field names as appropriate
Click OK and then click Replace.
The new timestamp field will now have the date and time data in one field.
Repeat the process for the closing date and time.
You can safely delete the old date and time fields (as long as they are not being used for anything else!)