Calculate Time differences

[Vijaykumar K]

Hi All, we have a request like ,

1.need to capture time difference between promoted on (date and time field) and current date and time untill restoration time(date and time) is empty and need to push this output to Time elapsed field(string field).

2.if Restoration is set the Time elapsed need to calculate between promoted time minus restoration time.

Could you pls help me with how to achieve this 

When to run before BR updated, major incident state is accepted.

[Arun_S1]

@Vijaykumar K You can use a calculated field which can calculate the difference and show the updated time when the incident is being queried.

But keep in mind that the script written in the calculated field will be executed every time the incident is queried from the database and may have a performance impact depending upon the calculation that is done.

Please mark the appropriate response as correct answer and helpful.

Thanks!!