A8:A31 are times from 0:00 to 23:00 and are part of a data query. The cells
are formatted as custom h:mm. C8:C31 are data from the same query although I
changed the data manually to check the results of the "lookup" (700 for 7:00,
705 or 5:00 aso) formatted as general. Also tried manually inputting some of
the times from A8:A31...no luck? Any thoughts, I'm stumped!

Jerry

"Sheeloo" wrote:

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