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?
 
Top