Formula calculating earnings during one shift when three different rates of pay apply

alex201280 

First I'd define rates for this and next days as

Next day is in bold here.

With that formula could be

=SUMPRODUCT(
  IF($B3>$H$3:$H$7,0,
      IF($G$3:$G$7>($C3+1*($C3<$B3)), 0,
          IF(($C3+1*($C3<$B3))>$H$3:$H$7,$H$3:$H$7,($C3+1*($C3<$B3)))-
          IF($B3>$G$3:$G$7,$B3,$G$3:$G$7)
     ) )*$I$3:$I$7)*24