Fermo Zolli
Technical User
Hello, everybody,
Tried many things but cannot get a good result.
I have created a group 1 with user ID and a group 2 with date.
Then in details I have all entries related as i.e.
08/12/19 05.43.59 IN
08/12/19 15.19.00 OUT
This user worked in first shift. All entries are sorted with a IN time and a OUT time. More problems come when the user is working on night shift as it enters one day and leaves the day after. Or when the user is going out for lunch and coming back, I get four entries. Sometimes a manitenance user is called at home and comes several times i.e. during the night, so the number of IN and OUT entries is increasing.
How can I calculate to total worked hours per day in a simple and sure way, please?
Is somebody able to give an help on this?
Kind regards, everybody,
Fermo
Tried many things but cannot get a good result.
I have created a group 1 with user ID and a group 2 with date.
Then in details I have all entries related as i.e.
08/12/19 05.43.59 IN
08/12/19 15.19.00 OUT
This user worked in first shift. All entries are sorted with a IN time and a OUT time. More problems come when the user is working on night shift as it enters one day and leaves the day after. Or when the user is going out for lunch and coming back, I get four entries. Sometimes a manitenance user is called at home and comes several times i.e. during the night, so the number of IN and OUT entries is increasing.
How can I calculate to total worked hours per day in a simple and sure way, please?
Is somebody able to give an help on this?
Kind regards, everybody,
Fermo