I am compiling a schedule spreadsheet for Clock In and Clock Out.
Different employees come in at different times of the day and leave according to their specific scheduled time.
Here is the example.
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.
Any ideas?