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.

[vukiczlatan]

Yuo don`t need to format cell as Currency, you may format as Custom and than add fomattype #.##0,00 "€/h"... instead of Euro, you can use any currency you prefer!!!

[FDibbins]

vukiczlatan thanks for the input

Dont know if you noticed, but this thread is over 10 years old

[vukiczlatan]

Of course I did! But as well as I found something intereseting in this 10 years old thread i hopped someone else in 10 more years might find somethins interessting my input too!