Forum Discussion
TIMESHEET CALCULATIONS
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.
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!!!
