Is it possible to calulate average of a time metric?

Hello,

I have a column for Avg Handle Time, where each row is formatted as:

0:00:00

How can calculuate the average of multiple rows?

I know with Excel, you can just highlight the whole column, and it'll calculate the average automatically. How would this be done in Smartsheet?

Thanks in advance,

-Cyrus

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

Paul Newcome

Smartsheet stores "time" as text, so you will need to first convert it into numerical values, run your calculations, then convert it back into the h:mm:ss format for display.

Here is a thread that has a handful of time based solutions that should provide you with what you need to make the conversions:

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

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.