how do you comepute for the absence in percent?
the data i have are: (we need to also conside leave early and late hours when computing for absence hours)
scheduled hours - the total hours an employee was scheduled.
absence hours - the total hours an employee was absent.
leave early hours - the total hours that wasn't completed by an employee, because they left early.
late hours - the total hours an employees was late.
is it something like:
scheduled hours / (scheduled hours + absence hours + leave early hours + late hours)