need formula for this
if you are late to clock in, you get a 1/3 of an occurance, one you have 3 late clock in you get a full occurance and then it starts over again
sample
5/24/06 1/3
6/25/06 1/3
7/1/06 1/3
you now have a full occurance
8/1/06 1/3
so total now you have 1 1/3 occurance
thanks in advance for any help
if you are late to clock in, you get a 1/3 of an occurance, one you have 3 late clock in you get a full occurance and then it starts over again
sample
5/24/06 1/3
6/25/06 1/3
7/1/06 1/3
you now have a full occurance
8/1/06 1/3
so total now you have 1 1/3 occurance
thanks in advance for any help