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 :
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...
36 freelancere byder i gennemsnit €27 på dette job
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
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.
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
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.
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.