I'm sorry. In column B for example the person was paid $346.83 (cell
formated in Accounting with two places after decimal point) and in column C
for example is 5:43 (cell formated in Time with the option of 13:30 format
selected). I'm using Excel 2007. Wigi when I tried the way you suggested it
gives me a larger dollar amount (takes hours as a fraction of day) but when
multiplied it still gives the wrong answer. Sorry for the confusion.

"Wigi" wrote:

That is not true.

(If you give so few information in your post, then I can't say more than
this).


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Railrd" wrote:

This does not give the correct answer

"Wigi" wrote:

Hi

Select cell D1.

Type:

=B1/C1

and hit the Enter button of your keyboard. Does the result make sense now?

(of course, if your numbers are not in row 1 but elsewhere, then you should
change the 1's in my formula.)

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Railrd" wrote:

In column "B" I have the amount someone is paid for a job. In column "C" I
have how many hours they worked on that particular job. In column "D" I
would like to display how much they got paid per hour. I have tried several
different ways but get the wrong answer or an error message.