"IF" only I could do this?

[Meebers]

Trying to check two cells to see if either is blank or has the text "n/a" in
them and not do the calculation. Using the formula so far
=IF(OR(F60="",(E60=""))," ",MOD(F60-E60,1)). I am working with time
formated cells 00:00 determining time between events. If I add to the
formula i.e. ,(F60="n/a" Excel says there is an error. TIA

 

[Dave Peterson]

Maybe you could just check for numbers (including times & dates) in both E60 and
F60:

=if(count(f60:e60)<2,"",mod(f60-e60,1))

 

[T. Valko]

Try it like this:

=IF(COUNT(E60,F60)=2,MOD(F60-E60,1),"")

 

[Meebers]

TX to Dave and Biff....both work...continuing to test for exceptions...

 

[T. Valko]

both work...continuing to test for exceptions...

There will be no exceptions! <g>

Thanks for the feedback!