Find the average of hours, minutes, seconds

Hi there,

I am having difficulties finding the average of hours, minutes and seconds. I have 12 months of data for timings, and the format is in hours, minutes, seconds how it is in excel - 00:00:00. I have to find the average for each month, for an entire years worth of data, and it gives me an error when I look for the average of each month. I am hoping to not reformat as I have so many figures it would take hours. Has anyone come across this before?

Thanks!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You are going to have to convert the times into numbers because Smartsheet is not currently capable of calculating time. There are a number of time based solutions in this thread that should help get you started.

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

All comments

Paul Newcome

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.