Closed

Create a spreadsheet to calculate staff hours.

I need a spreadsheet that can be used to calculate staff hours/pay as follows:

* The start and finish time of each day is variable and must be input in HH:MM format

* Each payment period starts on Thursday and finishes on Wednesday, 2 weeks apart

* Each day should have an un-paid lunch break, default value 30 minutes but may be changed for a particular day if required (some days staff may have 45 minutes un-paid lunch break)

* User must enter $ hourly rate

* After 8 hours work per day (Mon - Fri), the hourly rate increases to x1.5

* After 10 hours work per day (Mon - Fri), the hourly rate increases to x2.0

* On Saturday the first two hours are x1.5

* After 2 hours work on Saturday the hourly rate increases to x2.0

* On Sunday the hourly rate is x2.0

* Each day must show the total number of hours worked at each rate

* A summary table must be included to show the number of hours at each rate for the two week period

RDO Allowance:

* A check-box must be provided to select if the staff member participates in a RDO scheme.

* If the RDO box is selected and the staff member has worked for 8hrs that day, they only get paid for 7.6hrs standard rate - The remaining 0.4hrs is added to a "pool"

* If the RDO "pool" reaches 24hrs, the staff member is paid for 8hrs and no longer accumulates time in the pool - The maximum number of hours in the pool is 24.

Skills: Excel

See more: excel calculate work hours days, create magento based website hours, design create spreadsheet cost, data entry, data processing, excel, visual basic, microsoft, microsoft office, visual basic for apps, microsoft excel, excel webmaster spreadsheet calculate hosting, actionscript create spreadsheet, can create spreadsheet certain fields locked, calculate credit hours indian student, sql function calculate work hours, javascript calculate work hours, need excel spreadsheet roster staff free, calculate projected hours, free spreadsheet calculate financial ratios

About the Employer:
( 32 reviews ) Wangara, Australia

Project ID: #17705204

53 freelancers are bidding on average $147 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$222 AUD in 2 days
(628 Reviews)
8.3
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Create a spreadsheet to calculate staff hours. I can assure you the quality job. I have good experience in Excel. We have worked on several s More

$230 AUD in 3 days
(267 Reviews)
7.6
Webxpert4u

Hello, I am ready to write VB code in excel so you can calculate staff hours/pay. I need 24-48 hour maximum. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net f More

$250 AUD in 2 days
(187 Reviews)
7.7
KulfiSoftwares

I love excel, and have done several similar projects. I understand that you need to create a spreadsheet, that should calculate the staff hours.. Have read the description, and feel like a perfect match. ZERO ERROR More

$200 AUD in 3 days
(267 Reviews)
7.4
ksriniravi

Greetings! Thanks for detailed requirements. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can come up with an Excel Workbook as per r More

$120 AUD in 3 days
(156 Reviews)
6.6
dgled

Hi, I did similar projects in the past. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation More

$250 AUD in 3 days
(66 Reviews)
6.8
paris2785

Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to develop a spreadsheet that will traxck your employees working hours. You've added a compre More

$180 AUD in 5 days
(154 Reviews)
6.8
onlinejob247

Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Create a spreadsheet to calculate staff hour. Look forwar More

$300 AUD in 3 days
(76 Reviews)
6.1
javed1705

I am an ACCA (UK) professional , APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience. I can guarantee getting the job right More

$111 AUD in 1 day
(80 Reviews)
6.0
royalcalif

Let me review the spread sheet with atleast 2weeks data to calculate appropriate duration and cost as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy More

$30 AUD in 1 day
(66 Reviews)
5.5
satishtl

- Have done 4-5 projects related to timesheet, Wage calculations. - This includes off the total hours logged in a day removing the break hours Calcuatings based on the Hourly rate Saturday / SUnday or Public H More

$200 AUD in 4 days
(47 Reviews)
6.0
SShtv

I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a lot of experience in Excel, including the problem of automatic generation of schedules. These are screenshots of some of More

$150 AUD in 3 days
(62 Reviews)
5.7
TechnoGuruu

Hi, I have checked your project description and complete details that you want a tool to calculate staff hours and salary based on multiple criteria. I will build one efficient and quality product for you. I have ma More

$199 AUD in 5 days
(48 Reviews)
5.2
sonarkaushik

I am very able to create spreadsheet to calculate staff hours as per your requirement. I am ready to start. regards

$144 AUD in 3 days
(43 Reviews)
5.6
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com More

$155 AUD in 3 days
(29 Reviews)
4.8
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$50 AUD in 2 days
(51 Reviews)
5.1
tferreira67

Hi there, I believe to be a perfect fit to help you create am automated spreadsheet to calculate staff hours if you are looking for professional work. Please find below my relevant experience and qualifications f More

$155 AUD in 3 days
(5 Reviews)
4.4
serdaryalcin

Hello, It is a simple and easy project. You create a worksheet for each employee. When my macro runs, it will calculate the payment for each employee and share with you in a Summary worksheet as well. Please s More

$100 AUD in 5 days
(21 Reviews)
4.4
designer504

Hello! Thank you for stopping by our profile. We are a dedicated team of experienced and creative professional Graphic Designer having 6 years of experience who are truly passionate about creating stunning work. We ar More

$30 AUD in 0 days
(3 Reviews)
4.0
ilkecokay

Hello sir, first of all, thank you for writing your requests so clearly and spesifically. Not that everyone has an idea of what they want like you. About my bid, i can say that i am aware i don't have lots of reference More

$100 AUD in 2 days
(17 Reviews)
4.2