Forum Discussion
Impossible Data Transformation
Anonymous what are your requirements to get the first and last? what flags are you using? you need to give a bit more information about the rules you want to develop.
Do you want the first and last for each day, how do you know if they worked over night? etc..
Anonymous what are your requirements to get the first and last? what flags are you using? you need to give a bit more information about the rules you want to develop.
Do you want the first and last for each day, how do you know if they worked over night? etc..
vanessafvg, apologies, I incorrectly marked this as solved.
I'm trying to calculate the numbers of hour per employee, per day, spent at site (if they worked overnight, just number of hours spent there from one evening to th enext morning). The two "tricky parts" are:
. an employee may swipe in twice (only the first one should count)
. an employee may not swipe in and only swipe out, in which case we can assume the swipe in was 8 hours earlier.
Did I explain this correctly?
Anonymous dd you get this resolved?