Time

HSEBlack64

@Paul Newcome can you help. I have a formula that i had Gemini AI create that isn't working. for average time in mm:ss format. first can smart sheet display a result like this. 2nd if so, what is wrong with this formula?

=TEXT(((SUM([Total Match Time]:[Total Match Time]) / Stats4) / 60), "[0]") & ":" & TEXT(MOD(((SUM([Total Match Time]:[Total Match Time]) / Stats4) / 60), 60), "00")

HSEBlack64

@Paul Newcome

I found another thread you posted on i got this to work

=ROUNDDOWN(AVG([Total Match Time]:[Total Match Time]) / 60) + ":" + IF(MOD(AVG([Total Match Time]:[Total Match Time]), 60) < 10, "0") + MOD(AVG([Total Match Time]:[Total Match Time]), 60)

HSEBlack64

@Paul Newcome

I found another thread you posted on i got this to work

=ROUNDDOWN(AVG([Total Match Time]:[Total Match Time]) / 60) + ":" + IF(MOD(AVG([Total Match Time]:[Total Match Time]), 60) < 10, "0") + MOD(AVG([Total Match Time]:[Total Match Time]), 60)