View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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