So what I want to do is display the time it took to close a ticket. I got that to work but it also shows weird long times for the tickets that are still open.
When the ticket is created it automatically creates a ‘Timestamp’. When the ticket gets closed the user enters the date and time and the difference becomes the time the ticket was open otherwise I want it to display ‘Not Resolved’
This is what I have…
IF([Resolved]=True, ([Date Resolved]-[Timestamp]),“Not Resolved”)