In Progress

Excell Spreadsheet: Comptime payroll calculation

I need a spreadsheet that will calculate the over-time hours that an employee wants to add to his/her comp-time bank on a bi-weekly basis with yearly totals. The employee can only have up to 40 hours at one time saved in his/her comp-time bank and no more than 80 hours comp-time saved for an entire year.

The employee can use up to 8 hours of comp-time per day as long as they have enough hours in the comp-time bank to cover the used hours but cannot use more than 80 hours of comp-time per year. Validation rules must be applied to appropriate cells to prevent the data entry from not following the comp-time stipulations set above.

See Word document for more details.

Excel 2007 Workbook must have a worksheet for 20 employees (employee A, employee B, etc.) each with thier own bi-weekly and yearly totals.

Skills: Accounting, Data Entry, Excel, Human Resources, Visual Basic

See more: comp time spreadsheet, calculate comp time excel, comp time excel spreadsheet, comptime, comp time calculation, bank time spreadsheet, comp hours worksheet, comp time excel, spreadsheet comp time, comp time hours spreadsheet, payroll calculation spreadsheet, spreadsheet calculate comp time, comp time calculation spreadsheet, weekly payroll calculation worksheet, payroll calculation worksheet excel, comptime spreadsheet, comp time calculation worksheet, comp time use spreadsheet, calculate comp time, excel calculate comp time, excel spreadsheet payroll, comp time worksheet, weekly comp time spreadsheet, payroll calculation, hours cover

About the Employer:
( 3 reviews ) Sugar Grove, United States

Project ID: #527841

Awarded to:

xamdam91

Looking forward to working with you...

$30 USD in 0 days
(68 Reviews)
6.2

7 freelancers are bidding on average $69 for this job

lucky2gaf

Hi, please view my PM for details, thanks.

$60 USD in 1 day
(99 Reviews)
5.9
agihcam

Please refer to PMB.

$100 USD in 2 days
(42 Reviews)
5.2
nmppatel

I am an IT professional with 10 yrs experience. I have very good experience with Excel 2007, VBA. I have completed many projects on GAF in Excel skill. I will provide quick & professional service.

$60 USD in 1 day
(23 Reviews)
4.8
VPGroup

Pls contact me and give more detail, my yh id: soithaonguyen1987, my gamil id: lmkhoi.it Thanks anyway

$50 USD in 5 days
(0 Reviews)
0.0
llenz23

I would love to do this job for you with 100% accuracy. I do this on a daily basis at my full-time job. I actually figure offender's payroll by using an excel document. I have also done some Accounting study in college More

$150 USD in 7 days
(0 Reviews)
0.0
calboso

skilled in microsoft office. Hope to work with you soon

$30 USD in 5 days
(0 Reviews)
0.0