TIMESHEET CALCULATIONS

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!!!