View Single Post
  #1   Report Post  
wize
 
Posts: n/a
Default need help with a simple time formula

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.