On Sun, 10 Aug 2008 18:31:30 GMT, Lars-Åke Aspelin
wrote:

On Sun, 10 Aug 2008 18:58:07 +0100, "Sandy Mann"
wrote:

Even more interestingly if I do what you say in XL97 and then enter 8:00 in
B11, =A11-B11 returns 0.000000000000000 but as you say

=LOOKUP(A11*24,{0,8,16},{"Early","Day","Late"} )

returns "Early" and

=LOOKUP(B11*24,{0,8,16},{"Early","Day","Late" })

Returns "Day"


=A11*24-B11*24 returns -8.88178E.15

=24*(A11-B11) returns -7.99361E-15

=1*(A11-B11) returns -3.33067E-16

Lars-Åke

Furthermore

=(A11=B11) returns TRUE
but
=(A11-B11=0) returns FALSE

Lars-Åke