完了

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...

スキル: エクセル, Excel Macros, Excel VBA

さらに表示: 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

採用者について:
( 8件のレビュー ) zamudio, Spain

プロジェクトID: #21188865

アワード:

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 もっと

€30 EUR 2日以内
(41レビュー)
5.0

36人のフリーランサーが、このジョブに平均€27で入札しています

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 もっと

€40 EUR 2日以内
(108件のレビュー)
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 もっと

€30 EUR 1日以内
(89件のレビュー)
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 もっと

€18 EUR 1日以内
(60件のレビュー)
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 もっと

€150 EUR 3日以内
(63件のレビュー)
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 1日以内
(53件のレビュー)
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 もっと

€70 EUR 1日以内
(32件のレビュー)
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 もっと

€30 EUR 7日以内
(11件のレビュー)
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" もっと

€25 EUR 1日以内
(32件のレビュー)
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 1日以内
(11件のレビュー)
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 1日以内
(5件のレビュー)
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 もっと

€20 EUR 1日以内
(3件のレビュー)
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 もっと

€12 EUR 1日以内
(3件のレビュー)
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 もっと

€12 EUR 1日以内
(0件のレビュー)
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 1日以内
(0件のレビュー)
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 4日以内
(0件のレビュー)
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 4日以内
(0件のレビュー)
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 3日以内
(0件のレビュー)
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 もっと

€20 EUR 3日以内
(0件のレビュー)
0.0
aditya16131

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

€14 EUR 2日以内
(0件のレビュー)
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 1日以内
(0件のレビュー)
0.0