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

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.