Calculate billable hours excluding vacation, sick leave, and holidays

Currently, billability in HRM Insights is calculated as: billable hours ÷ total recorded hours. As a result, vacation and sick leave lower the percentage, even though they do not represent hours worked.

Desired: billability based only on hours worked; vacation, sick leave, and holidays should not be included in the denominator.

Example: 120 billable, 20 internal, 40 vacation, 8 sick → current 64%, desired 86%.

Goal: A clear understanding of how billable an employee is on days when he or she is actually working.