Excel time average?

I want to average time; Mon-Sun. if any day equal to 0 (0:00) don't average it. Formula I have is: =averageif(A1:A31,"<>0"). that works fine, what I really need is to exclude Sat and Sun as well as any 0 (0:00). thx.
1 answer 1