Calculate average time

Hello, I am trying to calculate average duration time for a date range. For example, on Monday I spent 23 min doing a project, on Tuesday I spent 35 min, on Wednesday I spent 15 min, etc. what is my Weekly Average?

When I enter the data as 0:23, 0:35, 0:15 and do an AVG formula, I get an error message. Any suggestions on how to do this formula? Thank you in advance!

Find more posts tagged with

Accepted answers

All comments

Sameer Karkhanis

AVG function requires numbers to calculate the average value. Values in your duration column are not numbers. Is there any reason you cannot specify them as 23, 35, 15? (You can always have the column header as "Time spent (in mins)"

Helen Rim

First, thank you for your response. The only thing with your suggestion is that I cannot use seconds. The average time spent we are trying to calculate is down to the seconds level - so trying to find the average time spent if we had 00:23:10, 00:35:45, 00:15:30. Sorry, I should have been more clear in my first post!

tosborne

If you haven't found an answer yet, maybe this can help.

I am only using minutes and hours so I reformatted my numbers to hr.min and used the formula below to find the average. It's not perfect, but it gets me pretty close to the information I need.

=IFERROR(AVG(CHILDREN()), "")

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.