On Sun, 27 Jul 2008 03:28:03 GMT, Lars-Åke Aspelin
wrote:

On Sat, 26 Jul 2008 20:05:00 -0700, F. Lawrence Kulchar
wrote:


Why does:

=LOOKUP(1.00001,--{"1";"1:"})

return a value of 0.0417 ??

Thanks,

FLKULCHAR


The double minus transforms the string "1:" to a value.
"1:" is seen as short for "01:00:00" which is a time value which is
1/24 or 0.041466666...

Format the output as time and you will see that it displays as
01:00:00

Hope this helps / Lars-Åke


Oops. 1/24 or 0.04166666... it should be.