Trying to set up a workbook that will find hourly wage

[atll]

Whats up guys? I am trying to set this up to work out, and I am already having problems. Here is the data that I just started with:

-----(A)---------(B)----------------------(C)--------------------(D)----------------(E)
Time in --- Time Out ---- (Time out - time in)*24 ---- Tips ------ Tips/column C

5:26 --------- 11:28 -------------- 6.033333333 ---------- $63 --------- $10.44198895
5:25 --------- 10:45 -------------- 5.333333333 ---------- $64 --------- $12

From my own calculation, these are both wrong, they are both off by cents. I double checked and I cannot find out what is wrong, but I am pretty sure the error is in the time calculation. If anyone could help that would be great. Thank you.

[JBeaucaire]

Except for your final calc, it looks fine:

   A 		   B		     C		   D		   E
Time In		Time Out	   Hours	  Tips		Tips PrHr
5:26 AM		11:28 AM	6.033333333	 $63.00 	 $10.44 
5:25 AM		10:45 AM	5.333333333	 $54.00 	 $10.13

C2: =(B2-A2)*24
E2: =D2/C2

[DonkeyOte]

Your calcs look fine to me (JB you used a different tips value in 2nd row to OP).

You may get discrepancies of a cent here and there given Rounding - perhaps limit the C & E levels of significance to 2 decimals? ie:

C2: =ROUND(24*(B2-A2),2)

E2: =ROUND($D2/$C2,2)

And on an aside if In/Out ever cross midnight might be better to use

C2: =ROUND(24*(MOD(B2-A2,1)),2)

[atll]

Ok, I am still having trouble with this, and my excel calculations are still not right. Here is a picture of what I am doing, the second picture is of the formula view. It would be great if someone could find something that I am doing wrong. Thanks again!

http://i29.photobucket.com/albums/c293/aares/excel1.jpg

http://i29.photobucket.com/albums/c293/aares/excel2.jpg

Also, I am not going from AM to PM or vice versa, so I dont have to worry about anything in that area.

[DonkeyOte]

Might be worth

a) outlining what you're expected results are ...
as I see it the formulae are correctly apportioning the tips per hour worked

b) posting an actual file as opposed to screenshots - the latter not being particularly useful
(people are generally disinclined to spend their own time replicating from an image when you could just post a sample file)