Spreadsheet: 686248d1594457065-count-every-4th-non-blank-cells-in-a-row-excluding-some-tsr
Sheet: Sheet1

 |  |  |  | 2020-06-01 00:00:00 |  |  |  | 2020-06-02 00:00:00 |  |  |  | 2020-06-03 00:00:00 |  |  |  | 2020-06-04 00:00:00 |  |  |  | 2020-06-05 00:00:00 |  |  |  | 2020-06-06 00:00:00 |  |  |  | 2020-06-07 00:00:00 |  |  |  | 2020-06-08 00:00:00 |  |  |  | 2020-06-09 00:00:00 |  |  |  | 2020-06-10 00:00:00 |  |  |  | 2020-06-11 00:00:00 |  |  |  | 2020-06-12 00:00:00 |  |  |  | 2020-06-13 00:00:00 |  |  |  | 2020-06-14 00:00:00 |  |  |  | 2020-06-15 00:00:00 |  |  |  | 2020-06-16 00:00:00 |  |  |  | 2020-06-17 00:00:00 |  |  |  | 2020-06-18 00:00:00 |  |  |  | 2020-06-19 00:00:00 |  |  |  | 2020-06-20 00:00:00 |  |  |  | 2020-06-21 00:00:00 |  |  |  | 2020-06-22 00:00:00 |  |  |  | 2020-06-23 00:00:00 |  |  |  | 2020-06-24 00:00:00 |  |  |  | 2020-06-25 00:00:00 |  |  |  | 2020-06-26 00:00:00 |  |  |  | 2020-06-27 00:00:00 |  |  |  | 2020-06-28 00:00:00 |  |  |  | 2020-06-29 00:00:00 |  |  |  | 2020-06-30 00:00:00
HOLIDAYS | [NAME] (7,14,21,28) |  |  | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL | TIME IN | TIME OUT | HRS WORKED | GROSS SAL
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:11:00 | 20:00:00 | 9.816666667 | 471.9853333 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:10:00 | 20:00:00 | 9.833333333 | 472.7866667 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:18:00 | 20:00:00 | 8.7 | 418.296 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 |  |  |  |  | 10:09:00 | 20:45:00 | 10.6 | 509.648 | 10:17:00 | 20:00:00 | 9.716666667 | 467.1773333
 |  |  | B
 |  |  | C | 09:00:00 | 20:00:00 | 11 | 564.08 | 10:00:00 | 20:00:00 | 10 | 512.8 | 10:00:00 | 20:00:00 | 10 | 512.8 | 10:00:00 | 20:00:00 | 10 | 512.8 | 10:00:00 | 20:00:00 | 10 | 512.8 | 10:00:00 | 20:00:00 | 10 | 512.8
 |  |  | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 11:50:00 | 20:00:00 | 8.166666667 | 392.6533333 |  |  |  |  | 10:11:00 | 20:00:00 | 9.816666667 | 471.9853333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:15:00 | 20:00:00 | 9.75 | 468.78
 |  |  | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 20:00:00 | 10 | 416.7 | 10:00:00 | 20:00:00 | 10 | 416.7 | 10:00:00 | 20:00:00 | 10 | 416.7 | 10:00:00 | 20:00:00 | 10 | 416.7 | 10:00:00 | 20:00:00 | 10 | 416.7 | 10:00:00 | 20:00:00 | 10 | 416.7 | 10:00:00 | 20:00:00 | 10 | 416.7
 |  |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8 | 10:00:00 | 20:00:00 | 10 | 480.8
 |  |  | G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 21:00:00 | 11 | 440.66 | 10:19:00 | 21:00:00 | 10.68333333 | 427.9743333
 |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:16:00 | 20:00:00 | 9.733333333 | 483.552 | 10:00:00 | 20:00:00 | 10 | 496.8 | 10:00:00 | 20:00:00 | 10 | 496.8 | 10:00:00 | 20:00:00 | 10 | 496.8 | 10:00:00 | 20:00:00 | 10 | 496.8 | 10:00:00 | 20:00:00 | 10 | 496.8
 |  |  | I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 20:00:00 | 10 | 464.7 | 10:00:00 | 20:00:00 | 10 | 464.7 | 10:00:00 | 20:00:00 | 10 | 464.7 | 10:00:00 | 20:00:00 | 10 | 464.7 | 10:00:00 | 20:00:00 | 10 | 464.7 | 10:00:00 | 20:00:00 | 10 | 464.7 |  |  |  |  | 10:09:00 | 20:45:00 | 10.6 | 492.582 | 10:00:00 | 20:00:00 | 10 | 464.7
 |  |  | J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 20:00:00 | 10 | 272.4 | 10:00:00 | 20:00:00 | 10 | 272.4 | 10:00:00 | 20:00:00 | 10 | 272.4 | 10:00:00 | 20:00:00 | 10 | 272.4 | 10:00:00 | 20:00:00 | 10 | 272.4 | 10:00:00 | 20:00:00 | 10 | 272.4 |  |  |  |  | 10:45:00 | 20:00:00 | 9.25 | 251.97 | 10:00:00 | 20:00:00 | 10 | 272.4