"Bruno Campanini" wrote in message
...

Sandy, a friend of mine - Franz Verga - modified =A2-A1+(A2<A1) in
=A2-A1+(A2<=A1).
As a conseguence whenever you have A1=A2 the formula
correctly thinks A2 pertaining to the next day and displays
24:00 instead of Null.
Provided you have the cell Custom formatted as [h].mm


Thanks for sharing that Bruno,

It also returns 24:00 if both cells are blank, if that is a problem then you
could add another test:

=A2-A1+(A2<=A1)*(A1<"")

--
Regards,


Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk