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