September 30, 2011 at 10:56 pm
Hi Friends,
please find requirement below:
eg: An employee's first IN is at 9.45 and last out is at 18.50 Total Hrs: T1 = 9hrs.05mts
In between, employee spends @ canopy(cafeteria) for 30 min.& goes out of office for 55 min.
(there may be multiple exits and entries at these doors in between first In and last out)
Total time spent 'out' = 85 mts. Time spent out in excess of 1 hour = 85-60 = 25 mts. (T2).
Attendance for the day = T1-T2 = 9hrs.05mts - 25mts = 8 hrs.40mts.
Input Parameter : employee_id and from_date
By this scenario i have to create a procedure. Pl help me on this.
September 30, 2011 at 11:14 pm
I'd like to suggest you give this a try a first. Show us what you have tried to accomplish your task.
However, before you do that, may I suggest that you start by first reading the first article I reference below in my signature block regarding asking for help. It will show you what you should post to get the best answers in return.
October 1, 2011 at 2:21 am
You could also spend some time and google for some more hints. This is a common question and there are several solutions out there.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply