79615847

Date: 2025-05-10 19:30:49
Score: 0.5
Natty:
Report link

This formula will count the number of blank cells starting in the column that matches the time entered in $B$1 (rounded down to 10-minutes) and moving to the right.

=XMATCH("*",OFFSET(D$1:CX$1,ROW()-1,XMATCH(FLOOR($B$1,"010"),D$1:CX$1)-1),2)-1
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: bricks96