Suljettu

Overtime, Scheduling and Timesheet excel expert

I really need to impress my boss for a promotion.

My document is messy so any help to make it look great would be helpful. Unfortunately my budget isn't that much.

My wishlist items are as follows:

1. The overtime calculations to be correct against the timesheet. Rules are in the OT_Code tab

2. Individual timesheets per staff member instead of everything on one sheet (can go up to 100 staff). Some VBA to make it hidden. the times are pulled through automatically from the Actual_Roster page by Vlookup on the Duty_Codes Page. Timesheets are only amended manually if someone is late. If not amended it sticks to default times.

3. A great dashboard that shows a whole bunch of stats, perhaps overtime, rostered shifts etc.

Currently number 1 is the priority.

Just to explain some things:

1. all staff names are pulled from the Staff_List sheet

2. All shift codes are pulled from the Duty_Codes sheet

3. All Overtime info is from the OT_Codes sheet

4. Actual_Roster is a duplicate of planned roster (changes made manually on actual_roster)

5. All dates are pulled from the Dashboard tab

6. My Hours Tab is for reference (I know my formulas are lengthy but I don't know excel well, but they seem to work). The labels are as follows:

*SH - Total Shift Hours

*BR - Total Break hours (1 every 5 hours)

*WD1 - Working hours (breaks have been removed) for day of shift start

*RH1 - Regular hours (04:00-21:00) for WD1

*NH1 - Night Hours (21:00-04:00) for WD1

*WD2 - Working hours (breaks have been removed) for next day if past midnight duty occurs

*RH2 - Regular Hours for day 2

*NH2 - Night Hours for day 2

I need the overtime calculations to go in the highlighted column under the Overtime Sheet. White column all hours passing 8 hrs that fall within (04:00-21:00) to go into this column. Dark grey column is for the night hours.

The tricky part is if someone is on a 12 hour shift and they finish at 22:00, 2 hours is overtime as a maximum of 8 hours is allowed with a 2 hour break. But 1 hour falls on the regular hours and one hour falls on the night. This has to be recorded accordingly.

Another example is if they finish a shift at 01:00 and have 3 hours overtime, 2 hours must be in the night range for day 1 and 1 hour must be in the night range for the next day.

I hope this will make sense to you.

NOTE: I know my date formula on my timesheet next to the individual times is incorrect. I'll fix that.

Taidot: Excel, Visual Basic, PHP, tietojenkäsittely, Tiedonsyöttö

Näytä lisää: daily timesheet template, excel timesheet formula with lunch break and overtime, weekly timesheet template excel, excel timesheet template with formulas, simple timesheet template, monthly timesheet template excel, free excel timesheet template multiple employees, daily timesheet excel template, toronto excel expert job, excel macro script reference, excel expert financial models, projekt expert fix, excel vsto cell reference, employee timesheet excel, money excel expert, need excel expert, excel expert independent contractor bid, expert fix, scheduling software excel price, excel expert finance job

Tietoa työnantajasta:
( 0 arvostelua ) Dubai, United Arab Emirates

Projektin tunnus: #27852853

13 freelancers are bidding on average $46 for this job

schoudhary1553

Hi, Greetings! ✅checked your project details: Overtime, Scheduling and Timesheet excel expert ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same ki Lisää

$60 USD 2 päivässä
(476 arvostelua)
8.3
P0L

(453 arvostelua)
7.8
dhanrajkarthick

Hi there, Gone through your requirements and i clearly understood what you need. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Kindly go through my profile and come back for the discussion. Lisää

$50 USD 2 päivässä
(33 arvostelua)
4.9
Usama0709

where lo is the amplitude of input current and k is the fee-space wave number. • Plot the 3-D polar pattern of the far-field at two different sets of view angles. • Plot the radiation pattern in the x-y plane (9 = 900 Lisää

$50 USD 1 päivässä
(1 arvostelu)
2.7
sscbe

Hi, I can do this project for you. I am good at Excel & creating macros. I have done a few projects in macros. I have an experience of 30 years & I am confident that I can do this project with out any error. I can pro Lisää

$50 USD 7 päivässä
(2 arvostelua)
2.5
AnuradhaVM

Hi, Greetings! ✅checked your project details. I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data analysis and MIS Management. I have strong analysis, and Excel skills and am able to provide Lisää

$45 USD 7 päivässä
(3 arvostelua)
2.0
faizan0017

Dear Boss, Greetings to you! I have read and understand every aspesct of your project. Will try my best to get you a big deserved promotion from your boss. Please come to chat and let me explain few things to you. Th Lisää

$50 USD 3 päivässä
(1 arvostelu)
1.3
sohidulislam571

Hello, From your job description I have learned that the requirements you have asked for data entry work excel sheet. I have proficiency in MS office. Working with me will surely bring you many good as I am very creati Lisää

$40 USD 2 päivässä
(0 arvostelua)
0.0
rahul896938

Hello sir, My name is Rahul Kumar and I have been working as a data entry specialist for over 2 years. I am a thorough researcher with an eye for important and relevant facts, and I am experienced in sortin Lisää

$15 USD 2 päivässä
(0 arvostelua)
0.0
Praveenkumarg235

I have read your job description and interested to deal with you. I am offering my service on short notice. Relevant skills and experience please consider me and give me a chance to impress you by my quality services.

$30 USD 1 päivässä
(0 arvostelua)
0.0
monir24mohai20

Hi sir, I can do this job in 4 days or as soon as possible. So you can hire me for your job at cheap rate. Thank you sir.

$45 USD 4 päivässä
(0 arvostelua)
0.0
FurkanAtaman

Hi My name is Furkan Ataman. I am Turkish. I have worked as Production Engineer for 5 years. Most of times, I used Excell, VBA coding and SAP ERP during working, scheduling ex. This is my first job as freelancer. I wi Lisää

$30 USD 3 päivässä
(0 arvostelua)
0.0
mccombsbeth

I have a Bachelor of Science Degree in Accounting from an accredited college - Western KY University - and 35 years of experience. I am proficient in payroll and payroll taxes. My data entry is extremely fast and have Lisää

$30 USD 7 päivässä
(0 arvostelua)
0.0