Thread: Averaging Times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David M David M is offline
external usenet poster
 
Posts: 10
Default Averaging Times

I am wanting to try and average times, but I do not want to include the 0:00
in the formula for the average. Is there something that I can use to simply
exclude the 0:00 from the formula entirely, unless they are filled out? Here
is what I am talking about:

0:01
0:10
0:00
0:07
0:08
0:00
0:35
Average here (not totalling in the 0:00)

Thanks,