I would like to automate this with following rules; For Clock In:
For Clock Out:
If the comparison cell is of Fixed value, than it is very easy. But if the comparison cell is variable like in my case, its a bit complicated. Have not been able to find any examples.