Try a little sample, if the value is 1 second it will lookup up the lookup
value and if not found the largest value smaller than the lookup value so
from 0 to 2.999 seconds it will lookup the zero and return 3Db, if 00:00:03
or greater but less than 00:00:06 it will lookup 00:00:03 and return 6Db and
so on. The only thing you need to do is to set the where you want that value
to be, I assumed 0 - < 00:00:03 and so on. If it would be <= 00:00:03 then
you would need to adjust to the smallest value you could use greater than
00:00:03 like 00:00:03.001

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




<michael.leonard@gmail.com> wrote in message
news:1143767377.395788.97480@u72g2000cwu.googlegroups.com...
>I see what your getting at.
> Bang on about the correction on the ranges, oops ;-)
> One thing that I should have mentioned is that the time value in L4 is
> generated from the two preceding time stamps. So there is a very good
> chance that L4 will have a time of 00:00:05 in it. That's why I was
> trying to write the conditional statements. Will the lookup table take
> that into account? Seems to me it only corilates the value to it's
> maching db value. But then again I am new to this
>
> Thanks again for the help I apreciate it
>