I'd like to report the summary statistics for a time variable.

I ran an experiment and I have the number of seconds that it took each participant to complete the study. I want to report the average amount of time it took them to complete the study (in minutes) as part of a summary stats table.

I've converted the seconds to minutes by multiplying it by 60 and I've converted the minutes to a time format:

Code:
gen Minutes = string(60e3 * Durationinminutes, "%tcMM:SS")
This does a nice job of
However, I can't report it in the summary states table. I've tried encoding the variable, but this produces the wrong results.

Any guidance would be greatly appreciated. I haven't been able to find the solution to this online.