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

Top