Need to average clock times

T

Tall Texan

I have clock times such as
0001:43
0003:37
0001:26
I need to average them, anyone know how? These are not AM/PM times. Think
of them as time spent doing a task, and I need to find the average time spent.
 
D

Dave Peterson

Enter them as real times:
hh:mm:ss
And then you can use =average().

But I'm not sure what 0003:37 means? What are those extra 0's at the left for?
 

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