One way...place this in C16, press ctrl/shift/enter, and
fill down:

=INDIRECT("M"&MAX((A16=$C$9:$C$11)*(A16<=$E$9:$E$ 11)*
{9;10;11}))

HTH
Jason
Atlanta, GA

-----Original Message-----
I hope I explain what I want to do and it doesn't sound
confusing.


In cells C9 C10 C11 I will enter in three different start
times in E9
E10 E11 I will enter in three different finish times in
M9 M10 M11 I
have three different numbers. In column A starting with
A16 down to A27
I have fixed times incrementing by one hour. What I want
to do is find
out what function to use in C16 down to C27 that
determines if the times
in column A are within the time range of C9 and E9 then
divide the
number in column B by M9 or if they are within the range
of C10 and E10
then divide it by M10 and the same for M11.

Thank you so much in advance if I have made myself clear.
David
.