Average HH:MM:SS

S

steve99

When I try to average the following times I get a div/0 error.

HH:MM:SS

00:02:44
00:01:11
00:18:57
00:21:19
00:00:49
00:07:42
00:01:35
00:11:44
00:03:19
00:37:06
00:01:27
00:32:58


I have formatted the cells with most every possible format type. An
idea's on how to get an average of times? FYI, I did it by hand an
the answer is 00:17:31

Cheers!
Stephe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the low value of a range of values 3
More than 24 hours 7
Determine # in system with Arrivals and Departures data 4
NEED HELP - Calculating dates and times 5
Overlapping time ranges 2
What is an automatic way to delete all rows of a certain kind 1
Time-problem 7
Windows 2000 Standby Fail on ThinkPad T22 4

Top