Færdiggjort

Modify or create a new excel file based in a existing excel file

I have a work attendance report in excel. See attached excel file [login to view URL]

With this file, I want automatically to generate one new or modify the same including the yellow row you see in the [login to view URL] attached

I need to count working hours of all days and show in that yellow row.

As example :

In first schedule, for Nombre:Josu, day 8 August, you see :

Enter 08:00

Exit 12:55

Enter 16:01

Exit 18:00

Enter 20:03

Exit 22:00

You have to rest : Exit - enter in each section, in this case, the total hours worked was:

12:55-08:00 = 3h.55m

18:00-16:01 = 1h.59m

22:00-20:03 = 1h.57m

Total = 7h.51m

You have to do this in all days and the total sum of all days put on the yellow row.

You have to do this for all workers... number of workers may vary, calendar could be 30-31 or less days...

Evner: Excel, Excel Macros, Excel VBA

Se mere: create excel file visual, php create excel file mysql, create avery labels excel file, create stand alone excel file, modify existing flash file, php code create excel file, create stand alone program excel file, create calculator based excel file web, open existing excel file visual, script create multiple accounts using excel file, create automatic emails outlook based excel file, input data existing excel file, send outlook based address excel file, open existing excel file owc11, read existing excel file cnet, net create solution based existing, create access database tracking excel file, can create app based existing, create conditional formatting for excel file

Om arbejdsgiveren:
( 8 bedømmelser ) zamudio, Spain

Projekt ID: #21188865

Tildelt til:

dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project don Flere

€30 EUR in 2 dage
(41 bedømmelser)
5.0

36 freelancere byder i gennemsnit €27 på dette job

younus15

I checked Both Excel files. I can do your project in less than 24 hours according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. I h Flere

€40 EUR in 2 dage
(108 bedømmelser)
5.9
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t Flere

€30 EUR på 1 dag
(89 bedømmelser)
6.0
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and and we can move forward with you Flere

€18 EUR på 1 dag
(60 bedømmelser)
5.7
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects i Flere

€150 EUR in 3 dage
(63 bedømmelser)
5.6
sajidkhan45

Hi, I am an excel VBA expert and have created various attendance sheet for different industries. This is a straightforward task for me. I Hope to chat with you soon mate! Gracias Sajid

€25 EUR på 1 dag
(53 bedømmelser)
5.5
bhupendrayadav

I am postgraduate with more than 6 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my port Flere

€70 EUR på 1 dag
(32 bedømmelser)
5.1
GopalJp

This is Gopal. I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part of my daily deliverable. I am a professional account Flere

€30 EUR in 7 dage
(11 bedømmelser)
4.3
shahinrahimi

I have rich experience in excel (advanced formulas, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" Flere

€25 EUR på 1 dag
(32 bedømmelser)
4.4
indrapandu

Hi, I have see the attachments. I am excel VBA expert, I can create macro that will count total hours worked for every worker in sheet and put in yellow color. Let's have a chat. Looking forward to hearing from you.

€24 EUR på 1 dag
(11 bedømmelser)
3.2
hkh581e5c8f1cb8a

Only 2 hours it'll be ready and perfect! fair price = 12 Euro. I'm a professional accountant who have 6 years of experience, Please check out mry profile and feel free to contact me. thanks

€12 EUR på 1 dag
(5 bedømmelser)
2.7
Aragornsan

Hi there, I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel report design, but can do most tasks needed in excel. I have a solid understanding of accounting Flere

€20 EUR på 1 dag
(3 bedømmelser)
2.7
Enganas1989

My Skills: Expert in Matlab. Expert in Microsoft office specially in excel. Expert in Degsilent. Good in Multisim. Arabic: Mother tongue. English: Modest user (IELTS). My Projects: 1- Short term Load forecast (Matlab Flere

€12 EUR på 1 dag
(3 bedømmelser)
1.2
ahmadnhas780

Dear Hiring Manager, Thank you for posting your job opening for Data Entry. I have five years of data entry experience and I have performed all of the duties listed in your job description. I have excellent typing spe Flere

€12 EUR på 1 dag
(0 bedømmelser)
0.0
HERNANDEZJB

Hi. I believe that my skills and experience make me a very competitive candidate for this job. I am highly qualified to deliver all the assistance you need. Responsible, commited.

€19 EUR på 1 dag
(0 bedømmelser)
0.0
DOAGuru

I am very Fluent in Excel and can help you in editing your EXCEL File. we have a team of 10 people who will finish your work in less time.

€12 EUR in 4 dage
(0 bedømmelser)
0.0
nikhilkamble8462

data entry excel ms office using software like Cloudie App and Midas Software And I have been working data entry work for last 2 years

€16 EUR in 4 dage
(0 bedømmelser)
0.0
nforhit

Satisfaction is my most desirable motive to my humble client. You will envy my VIP services if you give me an opportunity by hiring me. Thanks

€24 EUR in 3 dage
(0 bedømmelser)
0.0
wKeshani

Hi, I am an individual who is skilled and familiar with Microsoft Office package. And I am always responsible about the work that is been assigned to me. Therefore, I am confident that I will be able to handover the pr Flere

€20 EUR in 3 dage
(0 bedømmelser)
0.0
aditya16131

i am skilled is planning and organizing with the ability to complete tasks on deadline and independent worker who

€14 EUR in 2 dage
(0 bedømmelser)
0.0
ssameerahmed

Hi. Sir i can do your work in 2 day depending on your data. i can show you a sample as well. if you like it then assign me this task. i can work 10 hours a day. looking forward to work with you. regards.

€16 EUR på 1 dag
(0 bedømmelser)
0.0