Project Detail

Excell Spreadsheet: Comptime payroll calculation

Excell Spreadsheet: Comptime payroll calculation is project number 527841
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: xamdam91

Budget: $30-250

Created: 10/13/2009 at 22:05 EDT

Bid Count: 7

Average Bid:
$ 69

10/15/2009 at 22:05 EDT

Project Creator: bkellum
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (3 reviews)

Description

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.

Additional files submitted:
Excel Spreadsheet.doc

Report Violation

Job Type

See more: payroll calculation, validation rules, comp time, time bank, time hours, word document, data entry, spreadsheet, cells

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

10-13-2009 22:27 EDT

9.8409/10
(88 reviews)

Looking forward to working with you...

lucky2gaf

1 day

10-13-2009 23:02 EDT

9.8205/10
(39 reviews)

Hi, please view my PM for details, thanks.

nmppatel

1 day

10-13-2009 23:12 EDT

9.6897/10
(29 reviews)

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.

agihcam

100

2 days

10-13-2009 22:44 EDT

9.8667/10
(15 reviews)

Please refer to PMB.

VPGroup

5 days

10-13-2009 22:38 EDT

(No Feedback Yet)

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

llenz23

150

7 days

10-13-2009 22:40 EDT

(No Feedback Yet)

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. Thanks for considering me!

calboso

5 days

10-13-2009 22:51 EDT

(No Feedback Yet)

skilled in microsoft office. Hope to work with you soon

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.