Related Content: How to Calculate Total Hours Worked in a Week in Excel (Top 5 Methods) ❸ Now drag the Fill Handle icon to the end of the Production per Hour column.Īfter all the steps above, you will see the calculated production per hour amount for all the units as in the picture below:
D5 represents the Total Elapsed Time for the production in hours.