View Single Post
  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

I suspect that your Hours Worked is really an Excel time value that is
formatted to look like 4 hours. When you divide 200 by 1200 you get
0.166666, which is the decimal equivalent of 4 hours/24 hours in a day.

To get what you are looking for use the a formula that does this:
$200/(Hours Worked x 24):
=A1/(A2*24)

Does that help?

Regards,
Ron