Find Jobs
Hire Freelancers

Excel Format - Formula

$10-30 USD

Closed
Posted over 1 year ago

$10-30 USD

Paid on delivery
Hello, I want to have a chart that is automated so when I selected a date it would look for that day in all of the sheets and find all the employees that work. Then generate a report to show ever hour for when they arrive to work, go to lunch, and leave work. Example is Smith leaves at 2 and Josh arrives at 5 I would like it to show a chart of the hours and under 2PM show that smith is leaving and under 5PM show that Josh is coming in. I did attach a Example File would at lease see a screenshot of what the chart looks like before purchasing. UPDATE: I have attached a photo of what I'm looking for
Project ID: 35619244

About the project

118 proposals
Remote project
Active 1 yr ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
118 freelancers are bidding on average $22 USD for this job
User Avatar
Sir, I am EXCEL ALL FORMULA'S, EXCEL VBA MACRO CODING Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant (Finalist) with more than 7 years of experience which includes 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"" and 3 years experience as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 263+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$55 USD in 1 day
4.9 (272 reviews)
7.3
7.3
User Avatar
Hello, I will be glad to help you with that. I am an experienced Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA & Macro) to perform Automation, Data Analytics, Data Visualization and various types of Calculations and Analysis. I will be happy to discuss further in detail.
$20 USD in 7 days
4.8 (234 reviews)
7.3
7.3
User Avatar
Hello there Iam excel level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards ILYAS
$30 USD in 1 day
4.9 (225 reviews)
6.2
6.2
User Avatar
I've carefully checked your project and really interested in this job. Can you send me a message? Then we can discuss the details and build a long term & healthy business relationship with each other.i have read all Job description in detail. Please consider me for this task and check in my profile all Relevant Skills and Experience. Quality results and satisfied customers are my main priorities. King Regard
$20 USD in 7 days
4.4 (114 reviews)
7.0
7.0
User Avatar
Hello sir/ madam I checked your project description. I can do Microsoft Excel formulas task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saaniya.
$30 USD in 1 day
4.8 (182 reviews)
5.7
5.7
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun.
$10 USD in 1 day
5.0 (38 reviews)
5.6
5.6
User Avatar
Hello Sir, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, Thanks
$20 USD in 2 days
5.0 (49 reviews)
5.5
5.5
User Avatar
Hi, I will help you with that in quick turnaround. I’m Advance Level Excel/ Google Sheets expert holding years of experience in utilizing advance level excel functions, creating Dashboards, Excel Macros & VBA to perform Data Analysis, Visualization, Automation and complex calculations. I’m interested to hear more about the project. I’d be pleased to discuss this further and get started for you as soon as possible. Thanks! Abdul Haseeb.
$10 USD in 1 day
5.0 (80 reviews)
5.5
5.5
User Avatar
Hi I can create the chart of employees in and out on a particular day as per the attachment in google sheet. Need to modify the way you are collecting the data in excel If you are interested ping me in chat
$30 USD in 2 days
5.0 (85 reviews)
5.1
5.1
User Avatar
Hello, I have expertise at EXCEL I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.
$20 USD in 1 day
5.0 (24 reviews)
4.9
4.9
User Avatar
Dear, I am writing to propose a solution for creating an automated chart in Excel that displays the work hours of your employees. This chart will allow you to select a specific date and generate a report showing the arrival, lunch, and departure times of all employees working on that day. To create this chart, I will use a combination of formulas and functions such as INDEX, MATCH, and OFFSET. This will allow me to search for the selected date in all sheets and retrieve the corresponding data for each employee. The chart will then be updated to show the work hours for that day, with each hour displaying the names of the employees coming in or leaving. I am confident that this solution will meet your needs and provide a useful tool for managing your employees' work schedules. Please let me know if you have any further questions or would like to discuss this proposal in more detail.
$20 USD in 7 days
5.0 (15 reviews)
4.2
4.2
User Avatar
Hi, I prepared simillar chart to attached photo. I can handle this task but I have a few questions. Attached data has a different format (in some cases hours are written without 0 at the begginnig or at the end is * symbol). Would it be possible to unify data format? If you are interested in my offer, please contact by private chat, I will share the file I did so far. Best Regards,
$30 USD in 4 days
5.0 (6 reviews)
3.6
3.6
User Avatar
Dear, I have reviewed your employee tracking Sheets requirements carefully, I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified data analyst with 10+ years of experience in automating task using Google Sheets and Excel. I develop high-quality visualized analysis reports and dashboards using Excel, Tableau, and PowerBI. Also, I am experienced in data analysis tools Python, SQL, Statistics, Access, Google Sheets, VB.Net, Tableau, and PowerBI. Looking forward to your call to start working immediately. Yours A Dardear
$30 USD in 7 days
4.9 (10 reviews)
3.4
3.4
User Avatar
Hello, read the project description, need automated chart by selecting a date.... I can help you create the required automation. I am expertise and experience of 3+ years in Excel Automation using VBA. Please message me to discuss more. Regards, Vikram
$30 USD in 5 days
4.9 (26 reviews)
3.1
3.1
User Avatar
Honestly, I possess all the skills and experience that you’re looking for. I’m pretty confident that I am the best candidate for this job role. It’s not just my background in the past projects, but also my people skills, which will be applicable in this position. On the other hand, I am a self motivated person and I try to exceed my superior’s expectations with high-quality work. Being a fast learner, I quickly pick up business knowledge related to my project. Lastly, I would like to add that I work well both as an individual contributor and also as a team member. Collectively, all these skills put together makes me a complete package for this job
$30 USD in 7 days
5.0 (6 reviews)
2.6
2.6
User Avatar
Hey, I'm really interested to assist you in the completion of your project after carefully going through your requirements. I have read your project description and think I can help. Let’s chat in more detail about your project needs. Waiting for your good response.
$15 USD in 1 day
5.0 (14 reviews)
2.4
2.4
User Avatar
Hi, I've seen both 2 attachment and I have no doubt that I can I make Automation Chart that do what you want and generate a report to show ever hour. I have 2 years experience in VBA Excel. What you ask for is very simple, for me The work will be completed very quickly maybe less than half an hour because the code will not require writing from scratch because I have worked on similar code I would be happy to discuss your project needs and how I can help you meet them. I hope you see my profile to see an example of what I did before After completing project, If there is any support then I'll be available to support I look forward to talking to you! Mina
$10 USD in 1 day
4.7 (4 reviews)
2.4
2.4
User Avatar
Hello, I am excited to apply for this project and believe that my skills and experience make me the perfect fit. I am highly motivated and committed to delivering top-quality work. I am also available to start immediately and am eager to get started on this project as soon as possible. I would love the opportunity to discuss this project further and understand your specific needs and requirements. Please don't hesitate to reach out to me via chat to discuss. Thank you for considering my application. I look forward to the chance to work with you and contribute to the success of this project. Thank You for your time reading this!
$30 USD in 1 day
4.9 (2 reviews)
1.4
1.4
User Avatar
Hi there, I'd be excited to build this out for you - looks like an interesting project. I can present this like in the picture you have given and would be happy to share an example with you before you award me the project.
$15 USD in 1 day
5.0 (3 reviews)
1.4
1.4
User Avatar
Dear Client, I read about attendance with hourly watch sheet requirement. I'll be happy to offer you my services for misc data entry & well connected automatic to each other. Fortunately, our team very experienced in Excel Data Entry & able to ensure that the task will be completed on time with high-level of accuracy and efficiency.
$18 USD in 4 days
5.0 (3 reviews)
1.4
1.4

About the client

Flag of UNITED STATES
Virginia Beach, United States
5.0
2
Payment method verified
Member since Mar 21, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.