thank you so very much...I wa was perplexed.

FLKulchar
"Lars-Åke Aspelin" wrote in message
...
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