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.
<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>
</tbody>
Please help me.
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.
21/03/2019 | 22/03/2019 | 23/03/2019 | 24/03/2019 | 25/03/2019 | 26/03/2019 | 27/03/2019 | 28/03/2019 | ||||||||||||||||
In Time | Out Time | Work Hrs | In Time | Out Time | Work Hrs | In Time | Out Time | Work Hrs | In Time | Out Time | Work Hrs | In Time | Out Time | Work Hrs | In Time | Out Time | Work Hrs | In Time | Out Time | Work Hrs | In Time | Out Time | Work Hrs |
0:00 | 0:00 | 0:00 | 0:00 | 11:11 | 20:43 | 9:32 | 11:10 | 20:38 | 9:28 | 10:49 | 20:55 | 10:06 | 10:56 | 20:11 | 9:15 | ||||||||
0:00 | 10:43 | 19:36 | 8:53 | 0:00 | 0:00 | 10:59 | 19:43 | 8:44 | 19:57 | 0:00 | 10:52 | 19:49 | 8:57 | 10:57 | 0:00 |
<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>
</tbody>
Please help me.