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)