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

已完成 已发布的 Nov 26, 2014 货到付款
已完成 货到付款

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.

数据输入 数据处理 Excel 项目管理

项目ID: #6789536

关于项目

21个方案 远程项目 活跃的Nov 28, 2014

授予:

macroPOL

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 更多

$100 USD 在3天内
(61条评论)
5.6

有21名威客正在参与此工作的竞标,均价$132/小时

Teloquence

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 更多

$147 USD 在2天内
(331条评论)
7.7
jubair7

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 更多

$100 USD 在3天内
(322条评论)
7.8
koolsidz

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not 更多

$111 USD 在5天内
(149条评论)
6.5
sonarkaushik

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 更多

$144 USD 在5天内
(98条评论)
6.2
bizwizz

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 更多

$200 USD 在3天内
(18条评论)
5.7
Vasilchenko

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

$80 USD 在2天内
(60条评论)
5.4
mkhrsunil

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 更多

$250 USD 在3天内
(11条评论)
4.7
dank111

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 更多

$166 USD 在4天内
(10条评论)
4.3
MKL7

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 更多

$50 USD 在5天内
(18条评论)
3.2
MasterExcel

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 更多

$30 USD 在3天内
(10条评论)
3.2
SrinivasaBagade

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 更多

$155 USD 在15天内
(4条评论)
2.6
svb90792

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 更多

$155 USD 在3天内
(1条评论)
2.3
dataentry032

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 更多

$155 USD 在3天内
(2条评论)
0.8
zulqarnain123

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 在3天内
(0条评论)
0.0
raji6669

A proposal has not yet been provided

$155 USD 在3天内
(0条评论)
0.0
leduc91

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 更多

$75 USD 在2天内
(0条评论)
0.0
agiordanoorsini

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 在3天内
(0条评论)
0.4