I am trying to figure out the formula to calculate what an hourly rate in $ for a given time.
I have column with the amount earned and a column with the hours expended to earn that money. I want a column that shows the effective hourly rate for that job.
EXAMPLE
Col A | $50.00
Col B | 0.5 hours
Col C | $100 – would be the effective hourly rate for that row.
( $50 for half hour work equates $100/HR rate )
I cannot seem to find a function to return a correct result.
Any help welcome.