Excel hourly including gratuity

[LindseyW]

Good Morning. I have been racking my brain trying to figure out why my Excel formula in NOT giving me the answer I'm looking for. My calculator is correct, but what is the formula.

If I worked 6.28 hours at 11.50 an hour, so =6.28*11.5*24, is going to show 74.37. Then I also made $127.12 in gratuity. What formula do I input into a different cell calculating my average hourly income for THAT DAY? In my calculator I enter this formula and it gives me the correct answer. 74.37+127.12=201.49/6.28=32.0843949, showing I made an average of $32.08 an hour.

What does the Excel formula look like for this.


Thank you in advance,
Lindsey

 

[Dave Patton]

Please clarify your data.
How much time was worked? Is your number 6.28 hours or 6 hours and 28 minutes (6.47)?

Excel 2010
	B	C	D	E	F
1	6.28	11.5	72.22	127.12	31.74
2	6:28	11.5	74.37	127.12	31.16
3
1e

Cell Formulas
Range	Formula
D1	=B1*C1
D2	=ROUND(B2*24*C2,2)
F1	=(D1+E1)/B1
F2	=(D2+E2)/(B2*24)