EE work several Unions in 1 week and want to prorate Union Dues and Fringe based on Hours Worked
Employee has Home Union 9999 but works several times a week for Union Local 8888
Pro rate Union Dues and Fringe for each Union based on Hours Worked at each Local.
Union 9999 worked 21 hours
Union 8888 worked 22 hours
Total Hours = 43
Union 9999 21/43=49% Union Dues and Fringe
Union 8888 22/43=51% Union Dues and Fringe
Is there a way to set this up to Auto Calculate? Is there anyone with any experience with this?