I am trying to check the data in the following file Input-01-Aug-2019.xlsx (18.1 KB)
If you can see the punch records column, there I want to check the miss punches data. For example: In every cell there should be only in and out data (i.e., 09:14:17(in),12:34:42(out)). If there is any in,in or out,out it leads to miss punch (i.e., 09:14:17(in),12:34:42(in) or 09:14:17(out),12:34:42(out)).
So if there is any miss punch in the above sheet it will automatically recognize and send an email to the particular employee.
Please help me to solve this.
Thanks in advance!