LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Table Help

I need to build a table into my spreadsheet

12.50 15.00 18.75 21.25
25.00 35.00 40.00 55.00
40.00 55.00 60.00 75.00
50.00 70.00 90.00 100.00
65.00 85.00 100.00 120.00


I typed the above into my spreadsheet but I cannot create a table.

How do I create this table or do I need a table at all?

I have a spreadsheet that I would like to calculate pay for my employees.
The get a special rate depending on how many times they do function. Also I
have different level for employees skill levels. Example

Level I
Jobs Pay
1 $15
2 $35
3 $55
4 $70
5 $85

Level IV
Jobs Pay
1 $21.25
2 $55
3 $75
4 $100
5 $120

I keep track of the numbers per shift

Exampe

Employee Start End Jobs Pay
John 0900 1500 5
Joe 0900 1200 2


John is a level 4
Joe is leve 2

I need the formula to calculate the pay column

Any ideas?

Thanks

Tom


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivit table- cell on spread sheet referencing pivot table field David M Charts and Charting in Excel 2 August 18th 07 07:46 PM
entry removed from source table remains in pivot table pull down EL in Melb. Excel Worksheet Functions 1 September 6th 06 07:59 AM
PIVOT TABLE - Summary Table into a Databasae Table. sansk_23 Excel Worksheet Functions 4 May 9th 05 07:45 AM
VBA Code for a pivot table to open database and to reference table current page Pete Straman Straman via OfficeKB.com Excel Programming 0 February 21st 05 03:57 AM
create a source table from a special pasted value dynamic crossed table Tom Ogilvy Excel Programming 0 September 29th 03 08:59 PM


All times are GMT +1. The time now is 01:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"