ExcelBanter - Need to average clock times

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need to average clock times (https://www.excelbanter.com/excel-worksheet-functions/175649-need-average-clock-times.html)

Tall Texan

Need to average clock times

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.

Dave Peterson

Need to average clock times

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?

Tall Texan wrote:

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.

--

Dave Peterson

All times are GMT +1. The time now is 06:58 PM.