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.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Gestão de projetos

Veja mais: 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

Acerca do Empregador:
( 39 comentários ) Coon Rapids, United States

ID do Projeto: #6789536

Concedido a:


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

$100 USD em 3 dias
(61 Comentários)

21 freelancers estão ofertando em média $132 para esse trabalho


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 Mais

$100 USD in 3 dias
(322 Comentários)

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 Mais

$147 USD in 2 dias
(331 Comentários)

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 Mais

$111 USD in 5 dias
(149 Comentários)

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 Mais

$144 USD in 5 dias
(98 Comentários)

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 Mais

$200 USD in 3 dias
(18 Comentários)

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

$80 USD in 2 dias
(60 Comentários)

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 Mais

$250 USD in 3 dias
(11 Comentários)

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 Mais

$166 USD in 4 dias
(10 Comentários)

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 Mais

$200 USD in 7 dias
(8 Comentários)

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 Mais

$30 USD in 3 dias
(10 Comentários)

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 Mais

$50 USD in 5 dias
(18 Comentários)

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 Mais

$155 USD in 15 dias
(4 Comentários)

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 Mais

$155 USD in 3 dias
(1 Comentário)

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 Mais

$155 USD in 3 dias
(2 Comentários)

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 Mais

$75 USD in 2 dias
(0 Comentários)

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

$155 USD in 3 dias
(0 Comentários)

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 [url removed, login to view] i am new in this market [url removed, login to view] if you give Mais

$155 USD in 3 dias
(0 Comentários)

A proposal has not yet been provided

$155 USD in 3 dias
(0 Comentários)

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 dias
(0 Comentários)

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 dias
(0 Comentários)