Excel Time Calulating Macro

Færdiggjort Opslået 5 år siden Betalt ved levering
Færdiggjort 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.

.NET Databehandling Excel VBScript Visual Basic

Projekt ID: #17117410

Om projektet

27 bud Remote projekt Aktiv 5 år siden

Tildelt til:

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 ( Flere

$390 USD in 3 dage
(757 bedømmelser)
8.5

27 freelancere byder i gennemsnit $242 timen for dette job

schoudhary1553

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

$300 USD in 4 dage
(359 bedømmelser)
8.0
P0L

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.

$350 USD in 5 dage
(353 bedømmelser)
7.4
Teloquence

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

$277 USD in 4 dage
(339 bedømmelser)
7.7
zekovicm

Hi there,I am Miljan,Excel Macro,VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it wit Flere

$277 USD in 2 dage
(137 bedømmelser)
7.4
elqueabandona

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

$270 USD in 5 dage
(242 bedømmelser)
6.9
zebracaro

I can do it for you quickly and exactly. Please contact me for saving your time and your money .

$400 USD in 10 dage
(128 bedømmelser)
7.1
dvcontact

Hi, I have examined your project description about creating an Excel Macros for tracking Paid Time off for Payroll. You can be confident that this project will be professionally completed. I can tell you about how Flere

$300 USD in 10 dage
(55 bedømmelser)
6.5
sloker18

I am proficient with excel macro/VBA development, I have read through your specification and attached document carefully, I believe I can deliver the macro to do the calculation as specified in your project, I am avail Flere

$200 USD in 2 dage
(107 bedømmelser)
6.3
Walshie1987

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

$160 USD in 4 dage
(9 bedømmelser)
4.7
quickapp100

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

$277 USD in 10 dage
(10 bedømmelser)
4.5
SeniorWebDev1

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.

$455 USD in 10 dage
(10 bedømmelser)
4.4
prasannjeetp

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

$166 USD in 3 dage
(48 bedømmelser)
4.6
INFINITYADVERT

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

$300 USD in 0 dage
(4 bedømmelser)
3.4
Salesj23

hi there I wok on excel spreadsheets using vba code and also gui interface your excel file requires vba code integrated with buttons as requested and work with multiple columns to get end result your work wont tak Flere

$100 USD på 1 dag
(10 bedømmelser)
3.6
JorgeBece

Hello, I can help with your project. Besides being an Excel in my old job I designed a similar sheet (I worked on Human Resources) If you want to know more about me or how I'd do the project, please, contact me. Thanks Flere

$50 USD på 1 dag
(11 bedømmelser)
2.8
osamasuleman

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

$277 USD in 7 dage
(1 bedømmelse)
0.2
Shubhambsd

Am jobless want earn with free lancer

$277 USD in 10 dage
(0 bedømmelser)
0.0
ravinarendra

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

$250 USD in 7 dage
(0 bedømmelser)
0.0
espanajv

My Greetings, and..Going Down to the Chase, I just saw your Workbook Template, as a matter of fact you dont have any knid of Code inside this Excel' Sheets, and Briefly i swa the instructions and i obly need to cod Flere

$111 USD in 25 dage
(0 bedømmelser)
0.0
phosking1

Hi, I have excellent experience working with Excel and Macros, and applying this to business solutions. I speak English, and can communicate via phone or email as required. My aim is to deliver a solution that meets Flere

$200 USD in 7 dage
(0 bedømmelser)
0.0