example #1

<tbody>

</tbody>

example #2

<tbody>

</tbody>

I am looking for some help with a formula that will calculate the pay for each employee based on the amount of hours that they work and their percentage. We pay our employees by the job, as seen in the examples. If they work the same amount of hours or get the same percentage per job I can figure this out but the trouble is when they work different hours. (Like employee #1 works 6 hours on the job and the other 2 work 11 hours) How can I keep the proportions or percentages the same?

In the 2 examples above I show what I would like it to look like for these amounts but if they did the job in less time or one employee works more hours the rates would change.

What I want to be able to do is enter the price per job and the hours that each employee works and then it will proportionally figure out their pay for that job.

Does that make sense? Thanks in advance.

(I am using Windows 7 and Excel 2007)

Payment per job | 55 | |

Employee | Hours | pay |

Employee #1 | 1 | 22 |

Employee #2 | 1 | 20 |

Employee #3 | 1 | 13 |

Total hours | 3 |

<tbody>

</tbody>

example #2

Payment per job | 554 | |

Employee | Hours | pay |

Employee #1 | 9 | 198 |

Employee #2 | 10 | 200 |

Employee #3 | 12 | 156 |

Total hours | 31 |

<tbody>

</tbody>

I am looking for some help with a formula that will calculate the pay for each employee based on the amount of hours that they work and their percentage. We pay our employees by the job, as seen in the examples. If they work the same amount of hours or get the same percentage per job I can figure this out but the trouble is when they work different hours. (Like employee #1 works 6 hours on the job and the other 2 work 11 hours) How can I keep the proportions or percentages the same?

In the 2 examples above I show what I would like it to look like for these amounts but if they did the job in less time or one employee works more hours the rates would change.

What I want to be able to do is enter the price per job and the hours that each employee works and then it will proportionally figure out their pay for that job.

Does that make sense? Thanks in advance.

(I am using Windows 7 and Excel 2007)

Last edited: