A8:A31 are times from 0:00 to 23:00 from a data query. Already tried manual
input...thought that was the problem...no luck!

"T. Valko" wrote:

A8:A31

I assume those are the sequential times like:

12:00 AM
1:00 AM
2:00 AM
3:00 AM
...
11:00 PM

How did you fill these times in? If you drag filled them then that's your
problem. Try *manually* re-entering them and see if that clears up the
problem.

--
Biff
Microsoft Excel MVP


"JCC" wrote in message
...
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