Calculate effective hourly wage formula

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.

guessing there is no time-formatted in Col B, so the Formula is simply:

=$A1/$B1

in words: divide A1 by B1
formatted as Currency.

1 Like