- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- WKLY HRS/WKLY PAY = Rate per HR

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

- Re: WKLY HRS/WKLY PAY = Rate per HR posted by Peo Sjoblom on Mon, 15 May 2006
- Re: WKLY HRS/WKLY PAY = Rate per HR posted by Biff on Mon, 15 May 2006