Completed

Hire an Excel Expert

Our HR Director wants a summary of employee clocking data.

He wants to see who is in shortfall of 8 hour schedule or who is in surplus of 8 hour schedule. thus shortage = negative / absentism or positve /overtime .

our clocking system can export raw data to excel , but we need some formula or app that can calculate/intake this hours from excel , process and calculate an individual's hours for period X . X can be days , weeks or 6 months.

Please advise.

Formula or APP

Skills: Data Processing, Excel

See more: excel experts forum, excel expert salary, excel programmers for hire, excel expert jobs, excel freelancers, excel expert online chat, excel experts online help, excel expert tutorial, need excel expert on hire, i need an excel expert to come and fix up our spreadsheets for a few days johannesburg, how to hire excel expert, hire excel expert tel aviv, hire excel expert for 2 hours, where can i hire excel expert, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, hire excel expert, excel expert on hire, excel expert hire, need excel expert create macro, need excel expert match columns

About the Employer:
( 0 reviews ) South Africa

Project ID: #15207563

Awarded to:

bouslimi1979

Hi, an Excel App (VBA button). But I need to see your source Excel file. Thanks Expérience et Compétences appropriées Excel coder Étapes proposées R1088 ZAR - m

R1088 ZAR in 1 day
(159 Reviews)
7.1

18 freelancers are bidding on average R1058 for this job

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an E More

R1578 ZAR in 2 days
(493 Reviews)
8.0
schoudhary1553

Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with exce More

R1500 ZAR in 3 days
(194 Reviews)
7.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia More

R1500 ZAR in 2 days
(172 Reviews)
6.7
mrbrave

HI, I have looked at structure and can develop a macro for you to process data and show report in days, week and months. I can deliver final macro within 2-4 hours. Relevant Skills and Experience I have completed ove More

R1000 ZAR in 1 day
(191 Reviews)
6.5
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones R10 More

R1088 ZAR in 1 day
(49 Reviews)
5.0
osmemon

I have 7 years of experience on developing model on excel and VBA. I can also favor you taking money in South Africa via Standard Bank. See my profile for client reviews. Relevant Skills and Experience Excel VBA More

R1222 ZAR in 1 day
(20 Reviews)
5.2
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. As you could see on my reviews I have experience with excel and I can help you to solve your issue. Please contact me by cha More

R350 ZAR in 1 day
(55 Reviews)
4.7
humayoonsheikh4u

Dear I will do your project as per your requirements by applying advanced excel formulas with conditional formatting Relevant Skills and Experience Excel

R557 ZAR in 1 day
(8 Reviews)
3.9
R340 ZAR in 2 days
(12 Reviews)
3.2
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

R800 ZAR in 2 days
(1 Review)
2.0
R1088 ZAR in 3 days
(0 Reviews)
0.0
haleem0786

i have good command over Ms excel especially pivot table, charts, Advance formulas etc. Do let me know more detail in PM Relevant Skills and Experience Ms Excel Proposed Milestones R555 ZAR - upon completion

R555 ZAR in 3 days
(0 Reviews)
0.0
vikramraov

i already have some predefined macros to populate this data. i can use that and complete your requirement in quick time. Relevant Skills and Experience MS Office expert (Word,Excel and PowerPoint), Software TEsting P More

R1088 ZAR in 3 days
(0 Reviews)
0.0
stefan460

For the short term I could build you a excel sheet with formulas that allows you to copy and paste fresh data and select a date range and summarize the data according to your spec. Long term = App. Relevant Skills an More

R500 ZAR in 2 days
(0 Reviews)
0.0
victoryvirtual

Hi there, my name is Victoria and I am a UK based freelancer. I have extensive admin skills and have spent the majority of my career working within the medical sector where I am used to dealing with high expectations. More

R1944 ZAR in 1 day
(0 Reviews)
0.0
R1088 ZAR in 3 days
(0 Reviews)
0.0
jefferrjohn

I have experience writing a payroll system taking time clock imports such as these. The output was a CSV file that was used for import to Microsoft Dynamics GP. Relevant Skills and Experience Wrote payroll system for More

R1750 ZAR in 5 days
(0 Reviews)
0.0