Hi,

This also checks they aren't both empty

=IF(COUNT(A1:B1)=0,"",IF(B10,B1/60,A1/60))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Trainee" wrote:

I'm in need of a formula in C1 that gives me the value of A1 divided into
60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
THANKS.