Hi Folks!

Here's a strange one for you.

Two cells with the same entry formatted as h:mm.

F1 = 23:00
C1 = 23:00

These are not calculated values.

Doing a simple Sumproduct and got incorrect results.
Traced back to the evaluation that F1 < C1.

I formatted both cells as GENERAL.

F1 = 0.958333333333334
C1 = 0.958333333333333

I then tried entering pairs of 23:00 in random cells but
could not reproduce the above.

Biff