WKLY HRS/WKLY PAY = Rate per HR

Giganews Newsgroups
Subject: WKLY HRS/WKLY PAY = Rate per HR
Posted by:  Fattbizkit (Fattbizkit.27vjbb_1147738801.5127@excelforum-nospam.com)
Date: Mon, 15 May 2006

I have a sheet with the following data:
WKLY HRS 36.99  WKLY PAY $671.81    RATE HR $18.16

I need to the formula to find the rate per hours. The problem I'm
having is that I cannot find the Excel function which formats 36.99 as
hours, not fractions of the day.
I have tried Custom> [h]:mm which results in 887:45 and I understand
that Excel is multiplying by 24. I have tried Custom> h:m which results
in 23:45.
It also seems that Excel is rounding the time. While I want Excel to
round the hourly rate I do not want the _time_ rounded.

Many, many thanks in advance!

--
Fattbizkit
------------------------------------------------------------------------
Fattbizkit's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34471
View this thread:http://www.excelforum.com/showthread.php?threadid=542319

Replies