Hello all.
I have a database that collects workers punch times. Table fields are as follows
(TransactionKey,UserId,Customer,PunchTime,PunchType)
I calculate the time spent at the customer by using a datediff between a "Punch in" and a "Punch out"
My issue is some users have started visiting customers multiple times a day. I now get the time spent from both visits as well as the cumulative time between the first punch in and the last punch out.
Is there a way to fix this?
Thank you
I have a database that collects workers punch times. Table fields are as follows
(TransactionKey,UserId,Customer,PunchTime,PunchType)
I calculate the time spent at the customer by using a datediff between a "Punch in" and a "Punch out"
My issue is some users have started visiting customers multiple times a day. I now get the time spent from both visits as well as the cumulative time between the first punch in and the last punch out.
Is there a way to fix this?
Thank you