FTE Calculation

 We have HR and advanced Benefits bot,Currenlty we received the requirment to extract FTE based on following factor:

FTE can be a fractional number and is defined as (hours worked / available working hours) in any given month.

For exempt resources (full time) this will be dictated by the number of business days they have been active in a given month divided by the total number of business days available in that month.

For non exempt resources (hourly) this will be dictated by the number of hours they have worked in a given month divided by the total number of working hours available in that month (given 8 hours/day and number of business days).