TIMESHEET CALCULATIONS

%3CLINGO-SUB%20id%3D%22lingo-sub-2854274%22%20slang%3D%22en-US%22%3ETIMESHEET%20CALCULATIONS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2854274%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20calculate%20total%20time%20(hours%20%26amp%3B%20minutes%20worked)%3F%20%26amp%3B%20Calculate%20the%20pay%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20attached%20worksheet%3A%20R3%20should%20be%20total%20hours%20%26amp%3B%20minutes%20for%20D3%3AQ3%3C%2FP%3E%3CP%3ERegular%20Hours%20should%20show%20max%20of%2040%20hours%20per%20week.%3C%2FP%3E%3CP%3EOvertime%20Hours%20should%20be%20total%20hours%20per%20week%20over%2040%20hours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2854274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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!!!