Copper Contributor

How do I calculate total time (hours & minutes worked)? & Calculate the pay?


The attached worksheet: R3 should be total hours & minutes for D3:Q3

Regular Hours should show max of 40 hours per week.

Overtime Hours should be total hours per week over 40 hours.




2 Replies

@Robert Hart 

The values in columns D to Q were Text, so Excel didn't sum them. I have converted them to Time, and added formulas. See the attached version.

Perfect!!! Thank you so much!!!