Pl. list the contents of A8:A31 and C8:C31...
How are the cells formatted? Pl. share the formatting details.

"JCC" wrote:

The lookup value I'm using is from the following string.
=IF(C32<10,TIME((B32-(H24-J33)),0,0),(J33-TIME(H24,0,0)))
The result of this string is being displayed as the correct time (4:00) but
referencing it as a lookup value (=LOOKUP(J24,A8:A31,C8:C31) the result being
displayed for the lookup function is the value for 3:00 not 4:00. I have a
column renerating the times (the same basic string of functions) and 10 out
of 12 lookup results are off by one hour? Only 9:00 and 11:00 are returning
the correct values. All the cells are formated the same as well? Anyone have
any ideas?

Thanks,
Jerry