Average of a string text variable

Hi All,

I am new to elastic search SQL , and canvas side of world.
I have a variable 'message' in which data comes in 't' text format and it has time duration coming in.
I need to take the average of that variable and need the output to come in "mm:ss" format.

Below is the sample of data that I have in my variable

message t

hi all,
request if someone can help with the above query