clock in , clock out and absence issue
In our company, planned working time is 7:00 to 16:00.
I have an approved absence request from 8:00 to 10:00, but instead of 8:00 I left company at 8:20.
So my time events are as below:
clock in = 7:00
clock out = 8:20 (instead of 8:00)
clock in = 10:00
clock out = 16:00
approved absence request = 8:00 to 10:00
my expectation from system:
delimit my absence from 8:20 to 10:00.
Which customization are necessary in which table or PCR or Schema?
I really appreciate any help you can provide.