I need help creating a formula in column AM to add up all the hours in column T for each individual employee listed in column R.
Then if the sum is greater than 8, the hours entered in to the cell in column T needs to be divided by the total hours worked that day by that employee, otherwise the value in the cell (=IF(sum(employee's daily total hours)>8,T7/sum(employee's daily total hours)*8,T7).
Bookmarks