Best way to Handle this

I have given a task to make a simple codes that can manage a raw data came from Stand alone fingerprint attendance device.

I start to code how to get data from device and its working now.

My next target now is to manage this according to attendance rules of my company.

Here is the raw sample data i read from device

Code:

---

1,2011/12/1,7:31,0
2,2011/12/1,7:32,0
3,2011/12/1,7:33,0
4,2011/12/1,7:34,0
1,2011/12/1,11:50,0
2,2011/12/1,11:51,0
3,2011/12/1,11:52,0
4,2011/12/1,11:53,0
1,2011/12/1,13:01,0
2,2011/12/1,13:02,0
3,2011/12/1,13:03,0
4,2011/12/1,13:04,0
1,2011/12/1,17:31,0
2,2011/12/1,17:32,0
3,2011/12/1,17:33,0
4,2011/12/1,17:34,0
1,2011/12/2,7:31,0
2,2011/12/2,7:32,0
3,2011/12/2,7:33,0
4,2011/12/2,7:34,0
1,2011/12/2,11:50,0
2,2011/12/2,11:51,0
3,2011/12/2,11:52,0
4,2011/12/2,11:53,0
1,2011/12/2,13:01,0
2,2011/12/2,13:02,0
3,2011/12/2,13:03,0
4,2011/12/2,13:04,0
1,2011/12/2,17:31,0
2,2011/12/2,17:32,0
3,2011/12/2,17:33,0
4,2011/12/2,17:34,0
1,2011/12/3,7:31,0
2,2011/12/3,7:32,0
3,2011/12/3,7:33,0
4,2011/12/3,7:34,0
1,2011/12/3,11:50,0
2,2011/12/3,11:51,0
3,2011/12/3,11:52,0
4,2011/12/3,11:53,0
1,2011/12/3,13:01,0
2,2011/12/3,13:02,0
3,2011/12/3,13:03,0
4,2011/12/3,13:04,0
1,2011/12/3,17:31,0
2,2011/12/3,17:32,0
3,2011/12/3,17:33,0
4,2011/12/3,17:34,0
1,2011/12/4,7:31,0
2,2011/12/4,7:32,0
3,2011/12/4,7:33,0
4,2011/12/4,7:34,0
1,2011/12/4,11:50,0
2,2011/12/4,11:51,0
3,2011/12/4,11:52,0
4,2011/12/4,11:53,0
1,2011/12/4,13:01,0
2,2011/12/4,13:02,0
3,2011/12/4,13:03,0
4,2011/12/4,13:04,0
1,2011/12/4,17:31,0
2,2011/12/4,17:32,0
3,2011/12/4,17:33,0
4,2011/12/4,17:34,0
1,2011/12/5,7:31,0
2,2011/12/5,7:32,0
3,2011/12/5,7:33,0
4,2011/12/5,7:34,0
1,2011/12/5,11:50,0
2,2011/12/5,11:51,0
3,2011/12/5,11:52,0
4,2011/12/5,11:53,0
1,2011/12/5,13:01,0
2,2011/12/5,13:02,0
3,2011/12/5,13:03,0
4,2011/12/5,13:04,0
1,2011/12/5,17:31,0
2,2011/12/5,17:32,0
3,2011/12/5,17:33,0
4,2011/12/5,17:34,0
1,2011/12/6,7:31,0
2,2011/12/6,7:32,0
3,2011/12/6,7:33,0
4,2011/12/6,7:34,0
1,2011/12/6,11:50,0
2,2011/12/6,11:51,0
3,2011/12/6,11:52,0
4,2011/12/6,11:53,0
1,2011/12/6,13:01,0
2,2011/12/6,13:02,0
3,2011/12/6,13:03,0
4,2011/12/6,13:04,0
1,2011/12/6,17:31,0
2,2011/12/6,17:32,0
3,2011/12/6,17:33,0
4,2011/12/6,17:34,0
1,2011/12/7,7:31,0
2,2011/12/7,7:32,0
3,2011/12/7,7:33,0
4,2011/12/7,7:34,0
1,2011/12/7,11:50,0
2,2011/12/7,11:51,0
3,2011/12/7,11:52,0
4,2011/12/7,11:53,0
1,2011/12/7,13:01,0
2,2011/12/7,13:02,0
3,2011/12/7,13:03,0
4,2011/12/7,13:04,0
1,2011/12/7,17:31,0
2,2011/12/7,17:32,0
3,2011/12/7,17:33,0
4,2011/12/7,17:34,0
1,2011/12/8,7:31,0
2,2011/12/8,7:32,0
3,2011/12/8,7:33,0
4,2011/12/8,7:34,0
1,2011/12/8,11:50,0
2,2011/12/8,11:51,0
3,2011/12/8,11:52,0
4,2011/12/8,11:53,0
1,2011/12/8,13:01,0
2,2011/12/8,13:02,0
3,2011/12/8,13:03,0
4,2011/12/8,13:04,0
1,2011/12/8,17:31,0
2,2011/12/8,17:32,0
3,2011/12/8,17:33,0
4,2011/12/8,17:34,0
1,2011/12/9,7:31,0
2,2011/12/9,7:32,0
3,2011/12/9,7:33,0
4,2011/12/9,7:34,0
1,2011/12/9,11:50,0
2,2011/12/9,11:51,0
3,2011/12/9,11:52,0
4,2011/12/9,11:53,0
1,2011/12/9,13:01,0
2,2011/12/9,13:02,0
3,2011/12/9,13:03,0
4,2011/12/9,13:04,0
1,2011/12/9,17:31,0
2,2011/12/9,17:32,0
3,2011/12/9,17:33,0
4,2011/12/9,17:34,0
1,2011/12/10,7:31,0
2,2011/12/10,7:32,0
3,2011/12/10,7:33,0
4,2011/12/10,7:34,0
1,2011/12/10,11:50,0
2,2011/12/10,11:51,0
3,2011/12/10,11:52,0
4,2011/12/10,11:53,0
1,2011/12/10,13:01,0
2,2011/12/10,13:02,0
3,2011/12/10,13:03,0
4,2011/12/10,13:04,0
1,2011/12/10,17:31,0
2,2011/12/10,17:32,0
3,2011/12/10,17:33,0
4,2011/12/10,17:34,0
1,2011/12/11,7:31,0
2,2011/12/11,7:32,0
3,2011/12/11,7:33,0
4,2011/12/11,7:34,0
1,2011/12/11,11:50,0
2,2011/12/11,11:51,0
3,2011/12/11,11:52,0
4,2011/12/11,11:53,0
1,2011/12/11,13:01,0
2,2011/12/11,13:02,0
3,2011/12/11,13:03,0
4,2011/12/11,13:04,0
1,2011/12/11,17:31,0
2,2011/12/11,17:32,0
3,2011/12/11,17:33,0
4,2011/12/11,17:34,0
1,2011/12/12,7:31,0
2,2011/12/12,7:32,0
3,2011/12/12,7:33,0
4,2011/12/12,7:34,0
1,2011/12/12,11:50,0
2,2011/12/12,11:51,0
3,2011/12/12,11:52,0
4,2011/12/12,11:53,0
1,2011/12/12,13:01,0
2,2011/12/12,13:02,0
3,2011/12/12,13:03,0
4,2011/12/12,13:04,0
1,2011/12/12,17:31,0
2,2011/12/12,17:32,0
3,2011/12/12,17:33,0
4,2011/12/12,17:34,0
1,2011/12/13,7:31,0
2,2011/12/13,7:32,0
3,2011/12/13,7:33,0
4,2011/12/13,7:34,0
1,2011/12/13,11:50,0
2,2011/12/13,11:51,0
3,2011/12/13,11:52,0
4,2011/12/13,11:53,0
1,2011/12/13,13:01,0
2,2011/12/13,13:02,0
3,2011/12/13,13:03,0
4,2011/12/13,13:04,0
1,2011/12/13,17:31,0
2,2011/12/13,17:32,0
3,2011/12/13,17:33,0
4,2011/12/13,17:34,0
1,2011/12/14,7:31,0
2,2011/12/14,7:32,0
3,2011/12/14,7:33,0
4,2011/12/14,7:34,0
1,2011/12/14,11:50,0
2,2011/12/14,11:51,0
3,2011/12/14,11:52,0
4,2011/12/14,11:53,0
1,2011/12/14,13:01,0
2,2011/12/14,13:02,0
3,2011/12/14,13:03,0
4,2011/12/14,13:04,0
1,2011/12/14,17:31,0
2,2011/12/14,17:32,0
3,2011/12/14,17:33,0
4,2011/12/14,17:34,0
1,2011/12/15,7:31,0
2,2011/12/15,7:32,0
3,2011/12/15,7:33,0
4,2011/12/15,7:34,0
1,2011/12/15,11:50,0
2,2011/12/15,11:51,0
3,2011/12/15,11:52,0
4,2011/12/15,11:53,0
1,2011/12/15,13:01,0
2,2011/12/15,13:02,0
3,2011/12/15,13:03,0
4,2011/12/15,13:04,0
1,2011/12/15,17:31,0
2,2011/12/15,17:32,0
3,2011/12/15,17:33,0
4,2011/12/15,17:34,0
1,2011/12/16,7:31,0
2,2011/12/16,7:32,0
3,2011/12/16,7:33,0
4,2011/12/16,7:34,0
1,2011/12/16,11:50,0
2,2011/12/16,11:51,0
3,2011/12/16,11:52,0
4,2011/12/16,11:53,0
1,2011/12/16,13:01,0
2,2011/12/16,13:02,0
3,2011/12/16,13:03,0
4,2011/12/16,13:04,0
1,2011/12/16,17:31,0
2,2011/12/16,17:32,0
3,2011/12/16,17:33,0
4,2011/12/16,17:34,0
1,2011/12/17,7:31,0
2,2011/12/17,7:32,0
3,2011/12/17,7:33,0
4,2011/12/17,7:34,0
1,2011/12/17,11:50,0
2,2011/12/17,11:51,0
3,2011/12/17,11:52,0
4,2011/12/17,11:53,0
1,2011/12/17,13:01,0
2,2011/12/17,13:02,0
3,2011/12/17,13:03,0
4,2011/12/17,13:04,0
1,2011/12/17,17:31,0
2,2011/12/17,17:32,0
3,2011/12/17,17:33,0
4,2011/12/17,17:34,0
1,2011/12/18,7:31,0
2,2011/12/18,7:32,0
3,2011/12/18,7:33,0
4,2011/12/18,7:34,0
1,2011/12/18,11:50,0
2,2011/12/18,11:51,0
3,2011/12/18,11:52,0
4,2011/12/18,11:53,0
1,2011/12/18,13:01,0
2,2011/12/18,13:02,0
3,2011/12/18,13:03,0
4,2011/12/18,13:04,0
1,2011/12/18,17:31,0
2,2011/12/18,17:32,0
3,2011/12/18,17:33,0
4,2011/12/18,17:34,0
1,2011/12/19,7:31,0
2,2011/12/19,7:32,0
3,2011/12/19,7:33,0
4,2011/12/19,7:34,0
1,2011/12/19,11:50,0
2,2011/12/19,11:51,0
3,2011/12/19,11:52,0
4,2011/12/19,11:53,0
1,2011/12/19,13:01,0
2,2011/12/19,13:02,0
3,2011/12/19,13:03,0
4,2011/12/19,13:04,0
1,2011/12/19,17:31,0
2,2011/12/19,17:32,0
3,2011/12/19,17:33,0
4,2011/12/19,17:34,0
1,2011/12/20,7:31,0
2,2011/12/20,7:32,0
3,2011/12/20,7:33,0
4,2011/12/20,7:34,0
1,2011/12/20,11:50,0
2,2011/12/20,11:51,0
3,2011/12/20,11:52,0
4,2011/12/20,11:53,0
1,2011/12/20,13:01,0
2,2011/12/20,13:02,0
3,2011/12/20,13:03,0
4,2011/12/20,13:04,0
1,2011/12/20,17:31,0
2,2011/12/20,17:32,0
3,2011/12/20,17:33,0
4,2011/12/20,17:34,0
1,2011/12/21,7:31,0
2,2011/12/21,7:32,0
3,2011/12/21,7:33,0
4,2011/12/21,7:34,0
1,2011/12/21,11:50,0
2,2011/12/21,11:51,0
3,2011/12/21,11:52,0
4,2011/12/21,11:53,0
1,2011/12/21,13:01,0
2,2011/12/21,13:02,0
3,2011/12/21,13:03,0
4,2011/12/21,13:04,0
1,2011/12/21,17:31,0
2,2011/12/21,17:32,0
3,2011/12/21,17:33,0
4,2011/12/21,17:34,0
1,2011/12/22,7:31,0
2,2011/12/22,7:32,0
3,2011/12/22,7:33,0
4,2011/12/22,7:34,0
1,2011/12/22,11:50,0
2,2011/12/22,11:51,0
3,2011/12/22,11:52,0
4,2011/12/22,11:53,0
1,2011/12/22,13:01,0
2,2011/12/22,13:02,0
3,2011/12/22,13:03,0
4,2011/12/22,13:04,0
1,2011/12/22,17:31,0
2,2011/12/22,17:32,0
3,2011/12/22,17:33,0
4,2011/12/22,17:34,0
1,2011/12/23,7:31,0
2,2011/12/23,7:32,0
3,2011/12/23,7:33,0
4,2011/12/23,7:34,0
1,2011/12/23,11:50,0
2,2011/12/23,11:51,0
3,2011/12/23,11:52,0
4,2011/12/23,11:53,0
1,2011/12/23,13:01,0
2,2011/12/23,13:02,0
3,2011/12/23,13:03,0
4,2011/12/23,13:04,0
1,2011/12/23,17:31,0
2,2011/12/23,17:32,0
3,2011/12/23,17:33,0
4,2011/12/23,17:34,0
1,2011/12/24,7:31,0
2,2011/12/24,7:32,0
3,2011/12/24,7:33,0
4,2011/12/24,7:34,0
1,2011/12/24,11:50,0
2,2011/12/24,11:51,0
3,2011/12/24,11:52,0
4,2011/12/24,11:53,0
1,2011/12/24,13:01,0
2,2011/12/24,13:02,0
3,2011/12/24,13:03,0
4,2011/12/24,13:04,0
1,2011/12/24,17:31,0
2,2011/12/24,17:32,0
3,2011/12/24,17:33,0
4,2011/12/24,17:34,0
1,2011/12/25,7:31,0
2,2011/12/25,7:32,0
3,2011/12/25,7:33,0
4,2011/12/25,7:34,0
1,2011/12/25,11:50,0
2,2011/12/25,11:51,0
3,2011/12/25,11:52,0
4,2011/12/25,11:53,0
1,2011/12/25,13:01,0
2,2011/12/25,13:02,0
3,2011/12/25,13:03,0
4,2011/12/25,13:04,0
1,2011/12/25,17:31,0
2,2011/12/25,17:32,0
3,2011/12/25,17:33,0
4,2011/12/25,17:34,0
1,2011/12/26,7:31,0
2,2011/12/26,7:32,0
3,2011/12/26,7:33,0
4,2011/12/26,7:34,0
1,2011/12/26,11:50,0
2,2011/12/26,11:51,0
3,2011/12/26,11:52,0
4,2011/12/26,11:53,0
1,2011/12/26,13:01,0
2,2011/12/26,13:02,0
3,2011/12/26,13:03,0
4,2011/12/26,13:04,0
1,2011/12/26,17:31,0
2,2011/12/26,17:32,0
3,2011/12/26,17:33,0
4,2011/12/26,17:34,0
1,2011/12/27,7:31,0
2,2011/12/27,7:32,0
3,2011/12/27,7:33,0
4,2011/12/27,7:34,0
1,2011/12/27,11:50,0
2,2011/12/27,11:51,0
3,2011/12/27,11:52,0
4,2011/12/27,11:53,0
1,2011/12/27,13:01,0
2,2011/12/27,13:02,0
3,2011/12/27,13:03,0
4,2011/12/27,13:04,0
1,2011/12/27,17:31,0
2,2011/12/27,17:32,0
3,2011/12/27,17:33,0
4,2011/12/27,17:34,0
1,2011/12/28,7:31,0
2,2011/12/28,7:32,0
3,2011/12/28,7:33,0
4,2011/12/28,7:34,0
1,2011/12/28,11:50,0
2,2011/12/28,11:51,0
3,2011/12/28,11:52,0
4,2011/12/28,11:53,0
1,2011/12/28,13:01,0
2,2011/12/28,13:02,0
3,2011/12/28,13:03,0
4,2011/12/28,13:04,0
1,2011/12/28,17:31,0
2,2011/12/28,17:32,0
3,2011/12/28,17:33,0
4,2011/12/28,17:34,0
1,2011/12/29,7:31,0
2,2011/12/29,7:32,0
3,2011/12/29,7:33,0
4,2011/12/29,7:34,0
1,2011/12/29,11:50,0
2,2011/12/29,11:51,0
3,2011/12/29,11:52,0
4,2011/12/29,11:53,0
1,2011/12/29,13:01,0
2,2011/12/29,13:02,0
3,2011/12/29,13:03,0
4,2011/12/29,13:04,0
1,2011/12/29,17:31,0
2,2011/12/29,17:32,0
3,2011/12/29,17:33,0
4,2011/12/29,17:34,0
1,2011/12/30,7:31,0
2,2011/12/30,7:32,0
3,2011/12/30,7:33,0
4,2011/12/30,7:34,0
1,2011/12/30,11:50,0
2,2011/12/30,11:51,0
3,2011/12/30,11:52,0
4,2011/12/30,11:53,0
1,2011/12/30,13:01,0
2,2011/12/30,13:02,0
3,2011/12/30,13:03,0
4,2011/12/30,13:04,0
1,2011/12/30,17:31,0
2,2011/12/30,17:32,0
3,2011/12/30,17:33,0
4,2011/12/30,17:34,0
1,2011/12/31,7:31,0
2,2011/12/31,7:32,0
3,2011/12/31,7:33,0
4,2011/12/31,7:34,0
1,2011/12/31,11:50,0
2,2011/12/31,11:51,0
3,2011/12/31,11:52,0
4,2011/12/31,11:53,0
1,2011/12/31,13:01,0
2,2011/12/31,13:02,0
3,2011/12/31,13:03,0
4,2011/12/31,13:04,0
1,2011/12/31,17:31,0
2,2011/12/31,17:32,0
3,2011/12/31,17:33,0
4,2011/12/31,17:34,0

---

Can anyone give me best idea or best way to manage that?
Every Employee has different specified schedule.
Some employee must IN at 8:00 AM and Out at 5:00 PM (Out and In at NOON is optional)
Some employee are schedule to IN at 3:00PM and Out at 5:00PM
And some employee has different time schedule in some other day..

The purpose is to monitor late (minutes) and anbsences and print hard copy of DTR.

No codes to show for now. I'm just thinking for best way for now...

thanks.

I guess the first part of the data 1,2,3,4 is the employee id.

First off, you would need to create a table to hold valid work times for each employee since each could be different if shift work is involved.

You then have another table that will store the captured data that you show. It will probably be keyed by employee Id and Start time/Date.

You may also require another table to assign planned absences like holidays, since on these periods the employee clearly would not be clocking in and you wouldn't want to mark them as late.

Yeah. That is employee ID, I forgot to mention that.
I'm working on the first table now to hold the employees valid work schedule.

I think what is best here, as with any project, is to write out the spec, in great detail like a POC (Proof Of Concept) or a functional spec.
Then it all becomes clear on the requirement and what you need and makes things easier in terms of what you need, where things go in your project.