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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> jlogan21
> ------------------------------------------------------------------------
> jlogan21's Profile:
> http://www.excelforum.com/member.php...o&userid=30111
> View this thread: http://www.excelforum.com/showthread...hreadid=517969
>

[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
Jennifer

[mphell0]

Yes that is correct.

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