I have a Category Field called Status, which has three options: Open, In-progress and Closed. I was wondering if I could get the Time of when the Category Field is selected as closed. The reason behind this is I want to Calculate the time between the Item being Created and Closed. e.g. Ticket was created at 14:07 and the ticket was closed at 17:23 (@ticketClosed - @ticketCreated). The time take is: 3 Hours 16 Minutes. I was wondering if this was possible using a calculation field and if not if there is another way around it.
Please sign in to leave a comment.