Ignoring entries when not in the correct format

Originally Posted by lukela85

I have a spreadsheet which calculates average delays of flights departing airports. If in the time departed cell there is an entry not in the time format ie flight delayed, this corrupts the data. Is there a way of getting the spreadsheet to ignore this entry if it does not match the correct format.

Thanks,

Luke

Suggest you use the =isnumber function. Here is the syntax

http://www.techonthenet.com/excel/formulas/isnumber.php

then couple it with an =if function.

ie. =if(isnumber(your cell), action if true, action if false)

Alan

Thanks, perfect result.

Marking as solved.