Basic Excel Spreadsheet - Urgent
- or -
Post a project like this310
£15(approx. $19)
- Posted:
- Proposals: 10
- Remote
- #3945204
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
6608173140641614975622225576315100568989379135624915189493612289433408
Description
Experience Level: Entry
I am in need of a spreadsheet that can work out pay for staff, using the information below. I would like 3 separate tabs, one for each group.
Staff are paid hourly, but pay varies depending on what time of day they work and how long for.
Group A working from 06:00 to 21:00 earn £30.00 per hour, and earn £45.00 per hour when they work between 21:00 - 06:00.
Their shifts will often cross over those times, for example:
Example shifts/pay: 14:00 to 21:30 = £232.50; 22:00 to 03:00 = £225.00; 19:00 to 02:00 = £285.00
This is the same scenario for two other roles.
Group B is paid £25.00 per hour between 06:00 - 21:00, and £35.00 per hour from 21:00 - 06:00
Group C is paid £20.00 per hour between 06:00 - 21:00, and £30.00 per hour from 21:00 - 06:00
Staff are paid hourly, but pay varies depending on what time of day they work and how long for.
Group A working from 06:00 to 21:00 earn £30.00 per hour, and earn £45.00 per hour when they work between 21:00 - 06:00.
Their shifts will often cross over those times, for example:
Example shifts/pay: 14:00 to 21:30 = £232.50; 22:00 to 03:00 = £225.00; 19:00 to 02:00 = £285.00
This is the same scenario for two other roles.
Group B is paid £25.00 per hour between 06:00 - 21:00, and £35.00 per hour from 21:00 - 06:00
Group C is paid £20.00 per hour between 06:00 - 21:00, and £30.00 per hour from 21:00 - 06:00
Emma H.
100% (15)Projects Completed
9
Freelancers worked with
9
Projects awarded
50%
Last project
16 May 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies