software

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 Customgt; [h]:mm which results in 887:45 and I understand
that Excel is multiplying by 24. I have tried Customgt; 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: www.excelforum.com/member.php...oamp;userid=34471
View this thread: www.excelforum.com/showthread...hreadid=542319=671.81/36.99

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Fattbizkitquot; gt; wrote
in message ...
gt;
gt; I have a sheet with the following data:
gt; WKLY HRS 36.99 WKLY PAY $671.81 RATE HR $18.16
gt;
gt; I need to the formula to find the rate per hours. The problem I'm
gt; having is that I cannot find the Excel function which formats 36.99 as
gt; hours, not fractions of the day.
gt; I have tried Customgt; [h]:mm which results in 887:45 and I understand
gt; that Excel is multiplying by 24. I have tried Customgt; h:m which results
gt; in 23:45.
gt; It also seems that Excel is rounding the time. While I want Excel to
gt; round the hourly rate I do not want the _time_ rounded.
gt;
gt; Many, many thanks in advance!
gt;
gt;
gt; --
gt; Fattbizkit
gt; ------------------------------------------------------------------------
gt; Fattbizkit's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34471
gt; View this thread: www.excelforum.com/showthread...hreadid=542319
gt;
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

quot;Fattbizkitquot; gt; wrote
in message ...
gt;
gt; I have a sheet with the following data:
gt; WKLY HRS 36.99 WKLY PAY $671.81 RATE HR $18.16
gt;
gt; I need to the formula to find the rate per hours. The problem I'm
gt; having is that I cannot find the Excel function which formats 36.99 as
gt; hours, not fractions of the day.
gt; I have tried Customgt; [h]:mm which results in 887:45 and I understand
gt; that Excel is multiplying by 24. I have tried Customgt; h:m which results
gt; in 23:45.
gt; It also seems that Excel is rounding the time. While I want Excel to
gt; round the hourly rate I do not want the _time_ rounded.
gt;
gt; Many, many thanks in advance!
gt;
gt;
gt; --
gt; Fattbizkit
gt; ------------------------------------------------------------------------
gt; Fattbizkit's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34471
gt; View this thread: www.excelforum.com/showthread...hreadid=542319
gt;