Excel Time Calulating Macro
$50-450 USD
Betalt ved levering
Scope of Work / Objective:
We are looking to get an Excel Macro created that will be used to help track our Paid Time off for Payroll
Deliverables:
1 Excel Book with a Macro for Calculation
I’ve got an Excel sheet with 4 worksheets:
First Sheet is Employee Hour Workbook
The second Sheet is Paid Time off Tracking
The third Sheet is Paid Time off Log
The fourth Sheet is Paid Time off Schedule
What we need to be done:
We need to get Column B, C, D, and E formatted to a consistent hour: minute: second formula
Steps this Macro Needs to do:
Section 1: PTO Calculation for Time Accrued
1. When this macro is executed (button) it will need to do the following
It will need to reference the PTO key here per employee
Then look up the Calculation Value on Fourth Sheet is Paid Time off Schedule
It will then need to multiply out the hours worked in the Regular Time Column (Employee Hour Worksheet) Col B to the PTO Level; Note PTO Time does not Accrue on Holiday or PTO Time Used
So for Example, if Employee J has a PTO level of “1” and worked 22:47 Hours it would multiply 22:47 hours by .0396 = .09022 and then convert the decimal place out to an hour and minute conversion. ** This calculation amount might need to be adjusted to hours and minutes instead of decimals **
It will add this to the amount available to use in Column H in the Employee Hour Workbook Worksheet and add this in the PTO Available worksheet up to the maximum amount allotted for the PTO Class
Section 2: PTO Calculation for Time Used
In this section we will want to subtract any PTO time used (if any) from the PTO time Available so For Example if an employee has 80:00:00 Hours Available and Uses 6:00:00 hours then the value remaining for the Column H Available would be 74:00:00
Section 3: Log File
This is in the third workbook – but for each time the macro is processed we want to generate a log file that will keep track of the PTO calculated along with amount used. I would prefer to keep this where the newest records were on top.
This long file needs to be time-stamped and done for each employee.
When we process payroll we tend to just reuse the last Excel Sheet and do a “Save As” for the most current time.
Projekt ID: #17117410
Om projektet
Tildelt til:
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 ( Flere
27 freelancere byder i gennemsnit $242 timen for dette job
Hello, I can help with you in your project Excel Time Calulating Macro. I have more than 5 years of experience in .NET, Data Processing, Excel, VBScript, Visual Basic. We have worked on several similar projects befo Flere
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
EXCEL PRO at your service. Please check my past reviews for your reference. I have ready both your files which you uploaded "Instructions" and "Examples Excel file" and I feel confident that i can implement it. Let Flere
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
I can do it for you quickly and exactly. Please contact me for saving your time and your money .
Hi, I've read your scope and it's something that is easily achievable. I'm Chris and I've had over 10 years experience working specifically on Excel and VBA for a range of businesses in the UK. I'm new to Freelancer an Flere
Hi we are a software development company from india in past 8 years me & my Team developed approx 10238 projects for global market , we try to satisfy clients needs . we developed lots of projects for several industr Flere
Dear sir. I read your proposal carefully and studied excel files. I can do your task perfectly. Please ping me. Delivery time is 2 days, with 450$. OK? I will do my best. Thank you.
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can make this macro for you that will perform all the tasks above mentioned and it can be used as payroll system. Please come on c Flere
I am an expert and have experience working in excel of 9 years. I can do any task related to excel. I have great knowledge of excel. I am always available to solve problem in excel. I am an expert and have experience Flere
hello we are a team of MS Office expert we can help you create a excel macro sheet to calculate your payroll as you said in your project details. let's chat to discuss it further and get your job done at the earliest Flere
I'm confident to deliver a quality work that would exceed your expectations. Besides being quick, I'm also very accurate in my work. Have worked on more complex projects - check my profile. Looking forward to hearin Flere