Calculate rate per hour

[Arjay]

Does anyone know how to calculate a rate per hour?

I have a value $108.10 and a number of hours 39:46:00, both of which
are changing on a regular basis.

The usual formula Value/Hours does not give a dollar value and does
not appear to be a logical result.

Any help would be appreciated.

 

[daddylonglegs]

Try

value/hours/24

format as currency

 

[CFD]

daddylonglegs is crrect: Excel stores all dates/times internally as #'s
of days since 0th Jan 1900 ... therefore if you type 12:00:00 into a
cell and format it as a general number, it should come up as 0.5 ... if
you format it as a date it will come up as 12:00pm 0th Jan 1900.

Anyway, the upshot is you need to multiply the time by 24hrs to get the
# of hours. So if Rate is in Cell A1, and hours is in cell B1, then the
rate per hour in cell C1 should be (A1/(B1*24)) and then format it as
currency.