Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I calculate average time per call in Excel?
For example Day 1 was 35 calls for 59 minutes and 12 seconds total time. in the format of 00:59:12, what is the real equation to average these? when I do the cells in the form of C2,C4, I get a completely wrong number
1 Answer
- PeteXXX2261Lv 45 years ago
Average is 00:59:12 / 35 = 00:01:41, The average function is used to average across a range of values , eg. if you had each of the 35 individual call durations in the range C4:C38 you would use Average(C4:C38). It basically sums the total of the cells and divides it by a count of the number of non blank cells. You already have this info in 2 separate cells C4 & C2.
So assuming the # of calls in C2 & total duration in C4 then the formula needed is:
= C4 / C2
