Flexi time summary report

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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.

Data Entry Excel

Project ID: #17780699

About the project

7 proposals Remote project Active 5 years ago

Awarded to:

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 More

£250 GBP in 10 days
(204 Reviews)
6.8

7 freelancers are bidding on average £154 for this job

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 More

£158 GBP in 2 days
(615 Reviews)
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 More

£82 GBP in 1 day
(254 Reviews)
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 More

£250 GBP in 5 days
(41 Reviews)
7.8
Khurramz

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

£50 GBP in 3 days
(356 Reviews)
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 in 2 days
(284 Reviews)
7.2