Time

@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")

Tags:

Best Answer

  • HSEBlack64
    Answer ✓

    @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)

Answers

  • HSEBlack64
    Answer ✓

    @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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!