Hi,

Thanks for the feedback. The +1 adds one day to the smaller time.

Govind.

a wrote:
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.