Question

Stephanie wants to see what percentage of her employees' total working hours are spent working overtime. In the cell, enter a formula that divides Sarah's overtime hours (cell C7) by her total hours worked (cell F7)

Answer 1

A formula that would allow us to know this fact is:

F7/C7

Step-by-step explanation:

The reason behind this answer is that in the first place we need to know how much hours the overwork hours of her employees represent from the total hours they work. Thus, we need to take the total overwork worked hours and divide them by the total worked hours. This will tell us what percentage of the overworked hours represent the total worked hours.