Forum Discussion

Osvaldo Panguane's avatar
Osvaldo Panguane
Copper Contributor
Jul 06, 2018
Solved

Calculate hours Percentage of different employees with variable total (long employees list)

Hi all, Is there anyone who can help me to overcome this issue. I have a large employees list and I would like to Calculate hours Percentage of different employees with variable total. Employee...
excel
  • Matt Mickle's avatar
    Matt Mickle
    Jul 24, 2018

    Please see screenshot for reference.  I would try using an Hlookup with a few reference numbers that are set up based on the number of repetitions:

     

    =HLOOKUP(I8,$E$9:$G$10,2,TRUE)

     

pranav trikha's avatar
pranav trikha
Brass Contributor
Jul 24, 2018

Greetings!

Please find the attached file.

The approach that have taken is

a. Calculate total hours of each project (refer range M4:N17)

b. Calculate % time each employee spends on respective project.

Thanks,

Resources