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
|