You can also copy Bob's formula down the column. It will work with both
cases.

--
Regards
Roger Govier
<a wrote in message ...
thanks.

both formulae worked,
but I would prefer the IF statement even though its abit longer.
since it applies to both cases of A1 B1 or B1 A1, i can drag the
formula down the whole column.

BTW, what does (time + 1) do to the smaller time?

thnks.