calculate processing time based on interruptions and restarts

Hi Anonymous 

Can you provide some sample data and expected result in table format? 

If your table has start time and end time of every interval, you can add a column to calculate the duration of every interval first. Then you can use Group by feature to get the average of intervals per ticket number. Group by ticket number column and calculate the average of interval duration in a new column. 

If you can provide some sample data, we can help provide a detailed solution. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.