"Dalena" wrote:
It is working for the first three time ranges, but
the last one is giving me zero for all times entered
in that range (6pm - midnight).
Here is my almost working formula:
=IF(AND(B10TIME(24,0,0),B10<=TIME(6,0,1)),
100%,IF(AND(B10TIME(6,0,1),B10<TIME(12,0,1)),
75%,IF(AND(B10=TIME(12,0,0),B10<TIME(18,0,1)),
50%,IF(AND(B10TIME(18,0,0),B10<TIME(24,0,1)),25%, 0))))

There is no time 24:0:0. Midnight is 0:0:0. So the following is
sufficient:

=IF(B10<=TIME(6,0,1),100%,
IF(B10<TIME(12,0,1),75%,
IF(B10<TIME(18,0,1),50%,25%)))

Note that in the second IF expression, we take advantage of the fact that we
failed the first test. So we know that B10TIME(6,0,1) is true; we do not
need to test it.

Similarly in the third IF expression.