MrExcel Publishing
Your One Stop for Excel Tips & Solutions

A little help please Hlookups


Posted by JIM on January 18, 2000 4:40 PM

Hi
Novice that I am, can you help.

I need to make a wage sheet run different pay rates by Hlookup , but the sum comes out wrong
TOTAL HRS 48.25
PER HOUR 5.80
A B C
39.00 9.25 0.00

£372.35

Could any one write me a formula that works

A single time B time and one half etc

Hopefully

Jim


Posted by James on January 19, 2000 1:22 PM

Hello
Allright I'll try and make it clearer, I am a student and my personal wage sheet is entered in columns, horizontally
I have a named range for 5 (A to E) rates,
My columns headers are :

Supplement Code
Overtime
Hourly Rate
Billable Hours
Basic Hours

Another thing that is confusing me is that I have had to have a seperate column to calculate my overtime @ double rate
Overtime Code (E)

If any one would like to help me out I would be very grateful, or if any one would like to make a suggestion I would also be very grateful

Jim
I would be delighted to recieve an Email of something which would be useful

Posted by Celia on January 20, 2000 1:48 AM


Jim
You might be able to find what you need at the following web site :

http://www.cpearson.com/excel/overtime.htm

Celia

Posted by jim on January 23, 2000 8:56 AM

Celia

Thanks very much

Jim