I need someone to create me a script in PHP to calculate attendance based on a CSV file.
Working hours are from 08:00 - 18:30,
After 18:30 is considered overtime.
If employee starts before 08:00 for example 7:45, we do not consider this time in overtime calculation
If employee leaves after 21:30 for example 21:45, we do not consider this time in overtime calculation, until another hour has been worked after 21:30 for example 22:30 is checkout time.
Friday is off.
I should be able to specify public holidays in the script.
The script should remove extra records which are at the same time of each other and duplicate records.
Output should be like the attached excel file, it should be displayed in HTML table.
My budget for this is $10-20.
Also please prefix ur bid with "OVERTIME" so i know you have read the spec.
15 freelancers are bidding on average $24 for this job
Hi there, I have read your project description and i'm confident i can do this project for you perfectly. I can finish your project in short time. kind regards.