Find Jobs
Hire Freelancers

Overtime Calculation Excel Sheet for 6 Employees

£20-250 GBP

Suoritettu
Julkaistu noin kuukausi sitten

£20-250 GBP

Maksettu toimituksen yhteydessä
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over 12 hours. Overtime is paid at 1x between 06.30 and 18.30 Mon-Fri and 1.5x between 18.30 and 06.30 and on weekends. Overtime is paid at 2x on bank holidays and if urgently required last minute. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of complex calculations and formulas - Previous experience in creating similar spreadsheets for payroll or HR purposes would be highly advantageous - Attention to detail is crucial to ensure the correctness of the calculations The successful candidate will need to provide a user-friendly template that will make it easy for me to enter the necessary data each month. Please submit your proposal along with any relevant examples of your previous work.
Projektin tunnus (ID): 38000468

Tietoa projektista

23 ehdotukset
Etäprojekti
Aktiivinen kuukausi sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
£0 GBP 1 päivässä
5,0 (981 arvostelua)
8,7
8,7
23 freelancerit tarjoavat keskimäärin £119 GBP tätä projektia
Käyttäjän avatar
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
£135 GBP 3 päivässä
4,8 (165 arvostelua)
5,8
5,8
Käyttäjän avatar
-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
£70 GBP 1 päivässä
5,0 (75 arvostelua)
5,6
5,6
Käyttäjän avatar
Hey, Good afternoon? I hope this proposal finds you well. As an experienced freelancer, I have honed my skills in Visual Basic, Data Entry, Excel, Microsoft Office and Data Processing and am confident in delivering top-quality work. If you could kindly message me, we can discuss and get started soon. I'm deeply grateful
£150 GBP 1 päivässä
5,0 (2 arvostelua)
2,9
2,9
Käyttäjän avatar
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
£65 GBP 1 päivässä
5,0 (4 arvostelua)
1,6
1,6
Käyttäjän avatar
Hi dear friend I am proficient in programming in asp.net core, vb.net, SQL, Excel, VBA and automation tools in the Windows environment.  Plus 15 years of challenging experience in organizations and 5 years in freelance work. I have done more than 100 projects, including sales CRM applications and graphic PDF invoices, management dashboards in Excel, SAP Excel warehousing, automation programs for technical calculations and human resource management, personnel salary calculations, calculation of technical service rates. and also Im expert in Windows Automation Systems and developing system and security programs in windows networks. There is nothing that I can't handle in Excel VBA ! once our chat starts ofcourse If you were interested, I will gladly send you some of my work samples that may not be in my current portfolio. In addition, I have strong problem-solving and creativity skills that have attracted my clients in the past. I invite you to try my services and see the quality of work I offer. for your job send your current data files + a detailed video of your workflow please i will try my best to create a flexible and innovative excel vba based application for your future use. Hoping for a successful and long-term cooperation
£150 GBP 3 päivässä
5,0 (1 arvostelu)
1,6
1,6
Käyttäjän avatar
Hello, Good afternoon Cat T.! I can do this Overtime Calculation Excel Sheet for 6 Employees project immediately while maintaining quality. My skills in Microsoft Office, Data Processing, Data Entry, Visual Basic and Excel are unmatched making me confident to produce high quality work within a short deadline. I have worked on similar projects with other clients who were impressed with the quality of my work. Please message me as I need some clarification. If awarded, I will start working immediately. Thank you so much Cat T.
£150 GBP 2 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I can build this calculation sheet, I got the clear idea about your project requirement and please ping me for further discussion. I can start it right now.
£50 GBP 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hi there, I believe I can help you with this project as i have the experience with Data Processing, Data Entry, Microsoft Office, Excel and Visual Basic. here is my portfolio: https://www.freelancer.com/u/ayesha0124
£250 GBP 8 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
As a data entry worker, i am meticulous, detail-oriented, and efficient. I excel at accurately inputting and managing large volumes of information, ensuring databases and systems are organized and up-to-date. My focus and reliability make you an essential asset for any data-centric project or organization.
£25 GBP 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hi, With over a decade of experience as a Chartered Accountant&Auditor, I’ve developed an extensive skill set that is essential for creating dedicated Excel templates tailored to specific business needs . My proficiency in complex formulae and calculations, along with my expertise in financial data management and analysis ensures that your overtime calculation spreadsheet will be built accurately and efficiently.
£75 GBP 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Good day Thank you for your proposal and the opportunity to possibly work with you! In reading your full brief, I am able to do the project for you, with all the requirements. In my last position, I created a Custome Overtime Spreadsheet updated and maintain the sheet on a monthly basis for the staff. I am known in my professional career, as being extremely accurate, meticulous and detail orientated with all my work. I have been a Professional Remote – Typist/Data Entry/Admin Manager/VA/PA & Secretary for 12 years with the same company. I solely was responsible for all Data Typing/Entry, from and to different formats & the upkeep & maintaining of all data on all programs & databases, for the entire company. In addition, I have a total of 16+ years’ experience in the roles of Data Entry, Administration, Manager. Please have a look at my Resume on my Profile, as this lists All of my experience, skills and attributes as an employee. I am new to the Freelancer.com platform, but not new to the necessary experience and skills. I am also more than willing to provide you with a test sample, to ensure your satisfaction with my services. All work that I do for you is kept confidential and treated with utmost sensitivity. I would also very much like to send you my Contactable & Written Work References. Guinnevere Michelle Cloete
£170 GBP 50 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
As an Actuary with an extensive background in data-driven roles, I believe I am the perfect fit for your project. My 10-year career has provided me with substantial experience in quantitative analysis and financial modeling, where my Excel skills have played a pivotal role. I've relentlessly honed my abilities to execute complex calculations and formulas - an absolute requirement for your request of overtime calculations. While not directly HR-related, my work in general insurance has given me a deep understanding of payroll processes and how meticulousness is paramount to ensure accurate financial information. My proficiency in Excel is well-established and can be delivered to you in a user-friendly format, making it simple for you to enter the necessary data each month. I understand that creating an overtime calculation Excel sheet as per your requirements can be rather intricate, but my sharpened eye for detail will leave no room for errors while taking into account the intricacies of your specific needs. Let my relational and analytical skills provide you with trustable outcomes that will enhance your employee management. Looking forward to lending a hand on this vital aspect of your operations!
£250 GBP 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Being proficient in Excel and having a deep understanding of complex calculations, I believe I am the ideal fit for your project. Over my 17+ years of experience, I have handled numerous projects related to data processing and analytics, such as payroll and HR purposes which makes this particular project an excellent match for my skills. My attention to detail guarantees the highest level of accuracy in all your calculated fields. Moreover, with my profound experience in multiple industries encompassing manufacturing, finance, telecommunications, healthcare and retail, I can tailor-make the overtime calculation within your company context. I've often been lauded for my user-friendly templates that minimize data entry errors and increase work efficiency. My strong ethos of integrity, consistency and going above and beyond for quality work combined with effective time management will ensure project timeliness. Let me walk this journey with you till we achiev
£200 GBP 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hi, I Venkata Geetha, have hands on expertise in Mathematics, MS Office tools, R Program, Python, Tableau, Power BI. Have an experience in real-time business analytics. Regards, Geetha.
£135 GBP 10 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED KINGDOM lippu
Gillingham, United Kingdom
0,0
0
Maksutapa vahvistettu
Liittynyt huhtik. 16, 2024

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.