Try pasting these formulas into these cells

It worked for me, though it may be that I'm using some cells you need for other things!

I'm using column M for the factor 0 or 1, which is used to decide where the result goes.

If you're forced to use column N, for example, simply change all the M's to N's.

If you need more than 10 hour ranges, just continue the progression of formulas.

E2

=IF($M$2 = 0,0,ROUND($C$2*$D$2,2))

F2

=IF($M$3 = 0,0,ROUND($C$2*$D$2,2))

G2

=IF($M$4 = 0,0,ROUND($C$2*$D$2,2))

H2

=IF($M$5 = 0,0,ROUND($C$2*$D$2,2))

M2

=IF($I$2 >= $K18,IF($I$2 <= $L$2,1,0),0)

M3

=IF($I$2 >= $K$3,IF($I$2 <= $L$3,1,0),0)

M4

=IF($I$2 >= $K$4,IF($I$2 <= $L$4,1,0),0)

M5

=IF($I$2 >= $K$5,IF($I$2 <= $L$5,1,0),0)

M6

=IF($I$2 >= $K$6,IF($I$2 <= $L$6,1,0),0)

M7

=IF($I$2 >= $K$7,IF($I$2 <= $L$7,1,0),0)

M8

=IF($I$2 >= $K$8,IF($I$2 <= $L$8,1,0),0)

M9

=IF($I$2 >= $K$9,IF($I$2 <= $L$9,1,0),0)

M10

=IF($I$2 >= $K$10,IF($I$2 <= $L$10,1,0),0)