JE McGimpsey wrote:
Note that it's only nonsense using the 1900 Date system. It works fine
in the 1904 system...

I didn't realise that - thanks. I still prefer the solution where it
doesn't matter which setting is chosen; changing settings to make
things work has a tendency to come round later and bite you on the ass!




In article .com,
"Rob Hick" wrote:

So the reason it returns an error is because you are
asking it to format a negative number as h:mm, which
as far as it is concerned is nonsense.