Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You are high in the list of nominations for the most unhelpful response in
the group this month. Saying merely "This does not give the correct answer" does not give the contributors to the group (who are very willing to help) a great deal of chance to help you, particularly when the answer you were given is the correct answer to the question you asked. If you really do want help, you'll have to give more information, as there is a limit to the clairvoyant powers of even the brightest experts in the group. Why not start with things like: What values you have in B1 and in C1, what value you got from the suggested formula in D1, and what answer you expected? One specific question is about column C. Are you sure that it contains "how many hours they worked on that particular job"? If it is not a number of hours, but a time in Excel format, then you will need a factor of 24 in your formula. -- David Biddulph "Railrd" wrote in message ... 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I compute hours times hourly rate? | Excel Worksheet Functions | |||
How do i multiply an hourly rate by hours in Excel? | Excel Discussion (Misc queries) | |||
Hourly rate times hours? | Excel Worksheet Functions | |||
how do I calculate hours spent x an hourly rate? | Excel Worksheet Functions | |||
how to multiply h:mm value by an hourly $ rate | Excel Worksheet Functions |