WKLY HRS/WKLY PAY = Rate per HR

[Fattbizkit]

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!

 

[Peo Sjoblom]

=671.81/36.99

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Biff]

Hi!

Not sure what you want.......

If you want to convert decimal 36.99 to h:mm format 36:59

=36.99/24

Format as [h]:mm

Biff