Design an XLS that will format our payroll report and track employee's time.

We use 2 different databases to track and pull reports on employee's time. We also have some employees who are Salary and some who are Hourly. When we pull a report for a pay period, our hourly employee's time needs to be broken down to show true overtime (How many hours > 40 worked per WEEK, not per payperiod) and the export puts the time format as "8 hrs 34 mins", and the total shows the entire pay period. For Salary employees, we don't need the OT broken down, but we need their total time in a "88.42" format.

The other database that we use only exports data as a CSV or TXT, so currently, we are copying and pasting that data for each employee, because it does break the hours out the way we need it to.

So we are looking for someone to manipulate the spreadsheet so that when we export it displays the data the way we want it to, and we can quickly and easily grab the total hours to be entered in to our payroll processing website.

Skills: Data Entry, Data Processing, Excel, Project Management

See more: want employee, pull and pay, payroll processing in excel, employee needs, database entry salary, processing payroll, payroll how to, how to payroll, hourly employees, payroll so, looking for an employee, database employee, payroll time time, excel export txt, excel manipulate data, excel spreadsheet hours worked, excel payroll database, overtime database, employee time database, excel salary spreadsheet, excel spreadsheet payroll, payroll report design, use payroll excel, payroll data entry, spreadsheet need track

About the Employer:
( 39 reviews ) Coon Rapids, United States

Project ID: #6789536

Awarded to:


Hello, I can do this project. I did the first two sheets. Can you see it? [login to view URL] If you have any questions I will be happy to answer. If you are interested then I will be More

$100 USD in 3 days
(61 Reviews)

21 freelancers are bidding on average $132 for this job


Question: 1. I need to know if this report is data entry report or just interface to show analyzed results from database. And if its interface he need the database sheet to make the formulas! We can make it easier if More

$100 USD in 3 days
(322 Reviews)

Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. E More

$147 USD in 2 days
(331 Reviews)

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link then you will notice that I have not More

$111 USD in 5 days
(149 Reviews)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg More

$144 USD in 5 days
(98 Reviews)

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee More

$200 USD in 3 days
(18 Reviews)

Hi Ok. I can do macros which will summarize data and put it in right format. ....................................................................

$80 USD in 2 days
(60 Reviews)

Hi, I have Employee Time Tracker to track their work hours, Breaks daily basis. at end of day they will keep their tracker to shared folder. their will master file which you have to run daily basis. which will colle More

$250 USD in 3 days
(11 Reviews)

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can set up the exported payroll report into the format as desired. I have done US payroll reporting as well as calculators and I am awa More

$166 USD in 4 days
(10 Reviews)

Hi I can assure you that i am having the best excel experience and i can do almost everything possible with excel. Please check my review in IF you need see some samples of my work, then, pleas More

$200 USD in 7 days
(8 Reviews)

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

$30 USD in 3 days
(10 Reviews)

Dear, This is a very interesting project with two clear challenges and I would be pleased to have a closer look at it with you and hopefully get the opportunity to work on it. I am an Excel/VBA expert and have co More

$50 USD in 5 days
(18 Reviews)

Dear Employer, Good morning, I am interested in this job as I have over 18 years of experience in the field of MS excel & VBA programming, data-entry and I am a computer savvy, goals are to make the employer/ cust More

$155 USD in 15 days
(4 Reviews)

Hey I really would like to work on this project, Please share the details like what will be the Input Format for this data (means we are manually updating input or importing from any file), if u can share the input More

$155 USD in 3 days
(1 Review)

Hi, I'm Mahbub (Data Entry Expert) - ready to start your project at once. I will provide you 100% success work. ''When I start any work then I never think that it is my client's work, rather I always think it is my ow More

$155 USD in 3 days
(2 Reviews)

Hi mate, I have strong experiences in writing program to extract/manipulate data from excel files, EDI files or generate excel reports from database in ERP system. I will do my best to have good review from you. Wha More

$75 USD in 2 days
(0 Reviews)

Hello. I am a web developer with 11+-year experience . I work remotely on DigitalRay company - [login to view URL] - LA (USA). Technical knowledges: 1PHP JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symph More

$155 USD in 3 days
(0 Reviews)

Hello I am data entry,data prepossessing,Excel,Project management Expert.I have 2 year experience on this work and i am still do this work in another marker [login to view URL] i am new in this market [login to view URL] if you give More

$155 USD in 3 days
(0 Reviews)

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)

i will do this for you may be some one do this with low price rate but do this for in a efficient way because time saving is more impotent this is one time investment for saving money don't compromise on quality

$155 USD in 3 days
(0 Reviews)

I feel to be suitable for this role as my work experience in different company, as cost control and planning engineer i handle this kind of things a lot of time andrea

$35 USD in 3 days
(0 Reviews)