Calculate consecutive blank cell for each day - Attendance sheet

[bthmanish]

Hi,

I need your help to count blank in-time & out-time for a particular period in the attendance sheet. For example, 21st and 22nd March punching in and punching out both are blanks.
also, need to count how many days, in-time is recorded and out-time is not recorded.

[TABLE="width: 1560"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 3"]21/03/2019[/TD]
[TD="colspan: 3"]22/03/2019[/TD]
[TD="colspan: 3"]23/03/2019[/TD]
[TD="colspan: 3"]24/03/2019[/TD]
[TD="colspan: 3"]25/03/2019[/TD]
[TD="colspan: 3"]26/03/2019[/TD]
[TD="colspan: 3"]27/03/2019[/TD]
[TD="colspan: 3"]28/03/2019[/TD]
[/TR]
[TR]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[TD]In Time[/TD]
[TD]Out Time[/TD]
[TD]Work Hrs[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[TD="align: right"]11:11[/TD]
[TD="align: right"]20:43[/TD]
[TD="align: right"]9:32[/TD]
[TD="align: right"]11:10[/TD]
[TD="align: right"]20:38[/TD]
[TD="align: right"]9:28[/TD]
[TD="align: right"]10:49[/TD]
[TD="align: right"]20:55[/TD]
[TD="align: right"]10:06[/TD]
[TD="align: right"]10:56[/TD]
[TD="align: right"]20:11[/TD]
[TD="align: right"]9:15[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[TD="align: right"]10:43[/TD]
[TD="align: right"]19:36[/TD]
[TD="align: right"]8:53[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[TD="align: right"]10:59[/TD]
[TD="align: right"]19:43[/TD]
[TD="align: right"]8:44[/TD]
[TD] [/TD]
[TD="align: right"]19:57[/TD]
[TD="align: right"]0:00[/TD]
[TD="align: right"]10:52[/TD]
[TD="align: right"]19:49[/TD]
[TD="align: right"]8:57[/TD]
[TD="align: right"]10:57[/TD]
[TD] [/TD]
[TD="align: right"]0:00[/TD]
[/TR]
</tbody>[/TABLE]

Please help me.

 

[jondavis1987]

=COUNTBLANK(A1:G1) will count blank cells for you. You will need to change the range in that formula to the range you're trying to count

 

[jondavis1987]

=COUNTIFS(A6:F6,">0",A8:F8,"=") Use this formula to count the days where there's an in time and no out times. The first range, A6:F6 is for the in time ranges. The second range, A8:F8 is where you will put the out time ranges

 

[jondavis1987]

And I misread the first part of your sentence

=COUNTIFS(A6:F6,"=",A8:F8,"=") This will display the count for days where there is NO time in or out