Need to average clock times

  • Thread starter Thread starter Tall Texan
  • Start date Start date
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.
 
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?
 
Back
Top