I am trying to calculate rate of pay per hour by dividing earnings (format: currency) by time (format: [h]:mm).

However, the value is not correct. What do I need to change? 

Time is stored as a fraction so for example 07:00:00 is stored as 0.32.  If, as in this case you are working with hours, to get the answer you need, you need to multiply the time by 24.

Regards

• Proposed as answer by Clay Harryman 11 hours 34 minutes ago

That's great, thanks!