excelnovice2000
Member
Hello Gurus,
I am trying to breakdown each employee gross wages and other employer costs based on the number of hours each employee worked on a specific project
As an example
If employee Iron Man has gross wages of $3,125.00 and has worked on 4 different project and his hours worked are 31 hours. I want to breakdown the $3,125.00 to the 4 different projects based on 31 hours
Employee Gross Wages and other data is in Data tab. I have highlighted the expected result in green color in Sheet2 tab.
Really appreciate your help
I am trying to breakdown each employee gross wages and other employer costs based on the number of hours each employee worked on a specific project
As an example
If employee Iron Man has gross wages of $3,125.00 and has worked on 4 different project and his hours worked are 31 hours. I want to breakdown the $3,125.00 to the 4 different projects based on 31 hours
Employee Gross Wages and other data is in Data tab. I have highlighted the expected result in green color in Sheet2 tab.
Really appreciate your help
