TIMESHEET HOURS CALCULATION

£20-250 GBP

Completed

Posted

about 2 years ago

£20-250 GBP

Paid on delivery

Uses the day and date to determine hours worked on a shift. Daytime hours are 0600-2000hrs during the week Nighttime hours are 2000hrs-0600hrs during the week Saturday hours are midnight to midnight Sunday hours are midnight to midnight Bank holiday hours are midnight to midnight SATURDAY HOURS AND NIGHT HOURS CAN BE COMBINED INTO ONE TOTAL (SAME RATE) SUNDAY HOURS AND BANK HOLIDAYS CAN BE COMBINED INTO ONE TOTAL (SAME RATE Breaks taken during the shift are deducted from the longest portion of the shift. We export a spreadsheet which produces the report attached (excluding the calculation of the breakdown of hours). I am looking for an easy way to paste something to the export (which we do several times a week) and it will calculate the breakdown of hours according to the above, also looking up whether days are bank holidays etc. The file uploaded shows how the calculations should work - this has been done manually, we are looking to automate it.

Project ID: 33624286

About the project

35 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@paris2785

£0 GBP in 1 day

5.0

(488 reviews)

8.4

35 freelancers are bidding on average £142 GBP for this job

@khushh07

Hi, I can perfectly help you with your project. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Accounting ,Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. My Portfolio Items: https://www.freelancer.in/u/khushh07 My aim is to keep my client happy with providing accurate work within the time frame provided. There is no compromise on the quality and accuracy of work. Thanks & Regards Khushi

£125 GBP in 3 days

4.8

(361 reviews)

7.4

@suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU, POWER BI, and EXCEL tools like machine learning, deep learning, AI, NLP, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash

£250 GBP in 7 days

4.7

(91 reviews)

6.9

@raoarslan56

Read your job description carefully!!! Checked your attached file!!!! Understand your requirement completely!!! I have a strong grip on MS Excel (VBA/MACRO, Advance Filter, MACROS, Pivot Table, Vlookup, Hlookup, Data Validation, Conditional Formatting, Financial Templates, User form). You can check my reviews for excel project on my Profile wall. I'm detail-oriented, reliable, and efficient. I like working in Word and Excel, and English is my native language. I will produce high-quality results and would be interested in other work from you if you're satisfied with me! You can check my skills by giving me a sample assignment. or I can send you my sample work if you please text me.

£100 GBP in 1 day

5.0

(28 reviews)

5.2

@Lynne11

ACCOUNTING EXPERT Hello, I can help you out with the task. Kindly text me over the chats we discuss further.

£135 GBP in 2 days

5.0

(9 reviews)

4.4

@abhijangir31

I would love to do this work. I ensure you, your work will be done in time and with no errors guaranteed.

£249 GBP in 5 days

0.0

(0 reviews)

0.0

@andriyajermiya1

i am finished computer science i have all programming language(c,c++,c#,java,java script,html,dhtml,phython,php,.net, and more)translation(tamil,englih,telugu,malayaram,kannadam,hindi,chanish,arabic,spanish and more(45) language and artical writing exc...

£135 GBP in 1 day

0.0

(0 reviews)

0.0

@georpaul

I would want to work on this project .i am the best candidate for this job as i carry a lot of experience and work with data daily.

£135 GBP in 7 days

0.0

(0 reviews)

0.0

@AndreiPet

Hello. I do my work using excel a lot of times. I checked the sample you attached and I believe, I can do this project well using formulas, etc. I hope you'll pick me to do this task. Thank you.

£135 GBP in 7 days

0.0

(0 reviews)

0.0

@Chaitanyasonmale

look forward to contributing my skills and experiences to your organization if given the opportunity.

£120 GBP in 7 days

0.0

(0 reviews)

0.0

@d1mangolub

Hi I'm so interested in your project as I have enough skills on this field. I've pretty well versed in VB, Data Processing, PHP, Javascript, HTML, CSS, Web Design, MySQL. And also my career was based on honest, trustful and responsible activites of my own. So, I am sure I can do it and give you satisfy. I'd like to talk to you about the project in more detailed. Hope to land me your contact. Thanks.

£200 GBP in 7 days

0.0

(0 reviews)

0.0

@arslanshah86

Hi there I have study the file uploaded by you. I have very good understanding of work that you required to be done. So, I need a chance to give you satisfactory work.

£90 GBP in 1 day

0.0

(0 reviews)

0.0

@vinothmechanical

Dear Sir, Good Day! am willing to work your with project at the cost of 100 GBP kindly consider my bid and looking forward to your positive response

£135 GBP in 7 days

0.0

(0 reviews)

0.0

@sitisaidah83

I offer my service in a short notice, with my experience i have, I can provide the best service. I promise to give you a good quality results, it not too fast but i will give you a perfect results. But i need to talk to you to understand your need. We will discuss further for better understanding and results.

£200 GBP in 7 days

0.0

(0 reviews)

0.0

@mdsaifulislam324

Hello sir, My name saiful islam I am data entry expert. I have 2 years experience in this work . I have interested you job. I have work in your Project.

£135 GBP in 5 days

0.0

(0 reviews)

0.0

@mehedihnn

I am Mehdi I want to do your job You can give me this job and trust me that I will do your job properl

£135 GBP in 7 days

0.0

(0 reviews)

0.0

@anshrajsonkar02

Hello, I am interested in doing your project work. Let me know the details to start immediately. I will deliver high quality work consistently, meet deadlines, and maintain confidentiality with strict adherence to internal rules and processes. I am looking for words to this opportunity to work with you. Thank you Best regard, Ansh Raj Sonkar

£135 GBP in 5 days

0.0

(0 reviews)

0.0

@prajain18

I am interested in project , i can start immediately , so do elaborate on the time of submission so I can start working on your project.

£135 GBP in 7 days

0.0

(0 reviews)

0.0

@phils2900

Hello Client , i am a professional programmer for Software Development. I have several years experienced in c++, c, c# Excel , Excel macros, vba and more so I’m sure I can help you with the code . Don’t hesitate to contact me and discuss the details, Thank you.

£150 GBP in 4 days

0.0

(0 reviews)

0.0

@KingAhmadi

Dear Sir, As per your requirement and my knowledge you will be delighted to give me this job, I will perform it with 100% accuracy I am new freelancer and want to do my jobs with with lots of efforts to keep my client happy and find experience. thank you for providing opportunity. Regards, Ahmadi

£20 GBP in 7 days