I am making a spreadsheet in excel that will add subtract times and then
average the totals of multiples of these. My problem is that some of the
tiems do not need to be entered causing a # VALUE! in teh line where my
subtraction formula. This is fine and needs to stay this way. My problem is
that the average then has a #VALUE! instead of an average. How do I skip
over cells that have the #VALUE! ? I ammaking htis spreadsheet for someone
else, so I can not correct it each time this happens. This is what my sheet
is like:
A B C
1 1:15 1:30 15 =(B1-A1)*1440
2 12:30 1:00 30 =(B2-A2)*1440
3 3:15 N/A #VALUE! =(B3-A3)*1440
4 #VALUE! =AVERAGE(C1:C3)

Any suggestions to get the average to actaully average the amounts that are
not #VALUE! ??? Any help would be fantastic!!