Flexi time summary report

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

Attached is an excel file downloaded from our office front door system. The report is downloaded each week (the one attached is September 3rd to 7th) and is arranged by day showing each time an employee enters and exits the office which may be numerous times each day. What I require is a summary report extracting each persons first time clocking in and last time clocking out each day. Then a calculation of total no of hours for each day per person after deducting 30 minutes for lunch. Finally a total no of hours per person for the week.

Entrada de datos Excel

Nº del proyecto: #17780699

Sobre el proyecto

7 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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, they speak for themselves. Best rega Más

£250 GBP en 10 días
(204 comentarios)
6.8

7 freelancers están ofertando un promedio de £154 por este trabajo

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex Más

£158 GBP en 2 días
(615 comentarios)
8.3
Webxpert4u

I am ready to create fourlma or a Macro which will get a starting time and ending time of each person and qill calculate whole working hours for each one. Super easy task. I have done several several vba excel task. Me Más

£82 GBP en 1 día
(254 comentarios)
7.6
jkaranm

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Timo Más

£250 GBP en 5 días
(41 comentarios)
7.8
Khurramz

Hi Are there 10 people in total? Please reply me via chat .

£50 GBP en 3 días
(356 comentarios)
7.4
bdmultitech

Hi, I have check the attached file. I can do a summery of each employee working hours weekly or daily whatever you want. Please allow me to discuss with you. Regards Mynoor Rahman

£85 GBP en 2 días
(284 comentarios)
7.2