5 pm - 1 pm = .1667 of a day
200 / .1667 = 1200

(5 pm - 1 pm) *24 hours = 4 hours
200 / 4 = $50/hr

HTH,
Gary Brown



"wize" wrote in message
...
I am trying to divide a days pay by hours worked to give a wage per hour
amount.

ex. A1 $200.00 (days pay)
A2 4:00 (Hours worked)
A3 $50 ( I thought this should be =A1/A2)

My problem is A2 is a calculated field and I am getting weird results like
1200. What am I doing wrong?

Thanks for your help.