I think this post solves part of the problem
[Solved] How to show average duration - Need help - Bubble Forum
You can do a search for Support ticket message, format it to text and in the text do the subtraction between the 2 dates you want to compare, you apply split by with | and each item you convert it to a number and take its average
