Pay per hour?
 

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

Pay per hour?
 

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" wrote in
message ...

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

Pay per hour?
 

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
------------------------------------------------------------------------
jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111
View this thread: http://www.excelforum.com/showthread...hreadid=517969

Pay per hour?
 

Can someone tell me if the above is correct? As far as the time worked?
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

Pay per hour?
 

Yes that is correct.

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


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=517969