averaging time values

G

Guest

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weeks in a Calendar 2
Pivot Table Summarizing Quirk - Please Help 1
Macro for Copying pasting between different spreadsheets 4
Conditional Time Calculation 10
Averaging Time 8
counting absentees 1
Return a Specific Value 9
5 consecutively fail in burning DVD+R DL.... 7

Top