# Independent answer check

Put DateTime in H1, then =DATE(B2,C2,D2)+TIME(E2,F2,0) in H2 and fill through H5. Put =DATE(2026,10,22) in K2. The half-open SUMIFS returns $200 from SO-302 $120 and SO-303 $80. SO-301 $30 is too early; SO-304 $40 is exactly October 23 midnight and must be excluded.

Independent classification: Oct 22 09:00 and 17:30 satisfy start <= timestamp < Oct 23 00:00. 120 + 80 = 200. Oct 21 23:50 and Oct 23 00:00 are outside.