Forum Discussion
Robert Hart
Oct 17, 2021Copper Contributor
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 we...
HansVogelaar
Oct 17, 2021MVP
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.
- Robert HartOct 17, 2021Copper ContributorPerfect!!! Thank you so much!!!