How to show actual duration for incidents that are still open?

[e_wilber]

In list view we'd like to have an actual duration from when the record was open until it was displayed in list view. I thought a custom calculated duration field would do the trick but I guess calculations only happen on insert/update of the record rather than on display in list view.

What options do we have to have an accurate duration field when looking at our open records in list view?

[JP - Kyndryl]

Hi Wilber,

This can be done in creating a new function field in the task table (or incident if needed only there):

Then, add the Age field in the lists where you need it.

[Emily4]

Hey JP! 
This worked for me, however, the age keeps running after the ticket has been closed. 
Is there something else I can add to that function definition field to make it stop when the state changes to closed or active = false? Thanks! 

[AJugovic]

Any solution for this? I need the same.

[Michael_Nash]

@JP - Kyndryl Thanks for this, I also however have the issue when the ticket is closed it continues to run.