averaging time values

K

Karen

I have a worksheet with data per week that I need to average for the month. However, until all weeks are completed the Avg/Month is wrong. Is there a way around this:
Ex:
Wk1 Wk2 Wk3 Wk4 Wk5 Month Avg.
0:03:18 0:00:00 0:00:00 0:00:00 0:00:00 0:00:40
 
J

JE McGimpsey

One way, array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(A2:E2>0,A2:E2))
 
Top