Hourly wage

Easy one here hopefully:

See attachment. Picture 1.png

What formula should I put into R3 (hourly wage) so that it divides the profit by the total time.

I tried R3=P3/Q3 but I got $3.31 which is wrong. It should be around $10.60.

Thanks.

you need to convert 12:27 ( a time)
to number of hours, eg 12.48

=q3/z3*24

in z3 enter 23:59:59

then your formula will work

No joy. I got something like 1,072 ??

Q3 has the formula =SUM(I5:I54) if that is relevant.

Picture 1.png

Could you explain in more detail what I have to do because I'm a bit confused.

Thanks

Thanks but this is still not working. I put =P3/Q3/24 into R3 and got $0.12.

I'll start again.

Picture 2.png

In R3 I need to divide P3 by Q3 to get the hourly wage.

Codes are as follows:

N3: =P3/O3
O3: =SUM(F5:F54)
P3: =INDEX(L4:L101,COUNT(L4:L101))-L4
R3: ?

Thanks.

=p3/(q3*24)

ok, I just put =P3/(Q3*24) into R3 and it reads $0.12 which is wrong.
It should be $8.96.

I have a theory on this. If Q3 is the sum of a bunch of times, then the times are adding up to multiple days simply because Excel counts days as part of all times. Try changing your formula to =P3/(Q3-Int(Q3))*24.

Put in =P3/(Q3-Int(Q3))*24 and got $5,593.53

Just so no one spends any more time on this, it was posted here (OP's question has been answered): http://www.ozgrid.com/forum/showthread.php?t=86267