Pay per hour?

[jlogan21]

How can I figure this out? I have a cell for total time worked in this
format:
3:01:00. Then I have the total pay cell in currency for example:
$26.96. How do I find what the pay per hour works out to be? I tried
just doing division but it comes out wrong.
Thanks
Jennifer

 

[Trevor Shuttleworth]

Jennifer

If your start time is in cell B6 and your end time is in cell C6 the formula
in D6 to get a number rather than a time would be =(C6-B6)*24
formatted as general.

If that's in D6 and your total pay is in E6 then your formula in, say,
F6 would be =E6/D6

Regards

Trevor

 

[jlogan21]

Thank you for that and sorry it has taken me so long to reply. I did as
you stated and these are the results. Just wanted to make sure I am
doing this right.
Time IN: 7:59 AM Time Out: 1:42 PM

Total Time came out to be: 5.716667
Total Earned is: $57.60 and pay per hour is $10.08.

Just was a bit confused about the total time bein 5.71? Is that right?

Thanks again,
Jennifer

 

[jlogan21]

Can someone tell me if the above is correct? As far as the time worked?
Thanks
Jennife

 

[mphell0]

Yes that is correct.

5.716667 hours is the same as 5 hours, 43 minutes (0.716667*60)