Calculate rate per hour
 

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.


--
Arjay
------------------------------------------------------------------------
Arjay's Profile: http://www.excelforum.com/member.php...o&userid=32172
View this thread: http://www.excelforum.com/showthread...hreadid=519194

Calculate rate per hour
 

Try

value/hours/24

format as currency


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=519194

Calculate rate per hour
 

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.


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=519194