Calculate $ Earnings based on % of time on job

[BeardedSith]

Hello!!

I have a math problem I just can't seem to solve in Excel/Sheets. I know there's a way, because I've read about it in the past, but I also can't even remember what the problem is "called".

I need to calculate the profits of multiple employees based on the total haul for an operation, based on the percentage of time they were at the operation. The issue arises as soon as an employee isn't at the operation 100% of the time.

For example:
Total Haul: $1000
Employee 1 - 78% attendance - Gets 78% of 25% - but how do I factor back in the 22% this employee DOESN'T get?
Employee 2 - 100% attendance - Gets 25% or $250.00 of total
Employee 3 - 50% attendance - Same as above
Employee 4 - 100% attendance - Gets 25% or $250.00 of total

I could probably accomplish it in multiple formulas but there has to be an easier way to do this. Any insight, my genius friends?

 

[Eric W]

So you want to distribute the entire amount proportionately based on the attendance? Try:

Book1
	A	B	C
1	Amount:	$ 1,000.00
2
3		Attendance	Payout
4	Employee 1	78%	$ 237.80
5	Employee 2	100%	$ 304.88
6	Employee 3	50%	$ 152.44
7	Employee 4	100%	$ 304.88
8
9			$ 1,000.00
Sheet12

Cell Formulas
Range	Formula
C4:C7	C4	=B4/SUM(B$4:B$7)*$B$1
C9	C9	=SUM(C4:C7)

 

[BeardedSith]

Eric, you sir are a genius! Thank you very much!