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.
|