Hi All,
I am working in an attendance software,I am stuck in the following,

before pointing to the real problem i will tell you some features.
    1) There is no shift timing employee can swap
    the card any time and no restriction in number of swap.
    2) The timing can be night shift also.

My real problem is the second point, I thought that i can count the swap entry
for eg: in particular date first entry can be treated as "IN" second entry treated as "OUT" and goes on...,It was working fine if the time not going after "24:00" if it crosses then the
entry is considering again as "IN" because its a new day,

Can anybody have the logic for this????

One method would be to check the previous swipe.. If it is IN, then even if it crossed 24:00 it should be made as OUT

Another solution I can think of is to check the difference in hours. Assuming there are no continuous shifts, an IN can be re-registered only if there is a time difference of say 10-16 hrs. You can use datediff function for that (http://vbadud.blogspot.com/search/label/VBA%20DateDiff)

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shashur,
Thanx for your reply, First point you said will be valid only if "IN" done before 24.00, what if the last Swipe is for "OUT" before 24.00 hrs. then it will be considered as New day instead of OT hours.

and the next point i cant understand completely.

Hi

The second method has to do with the time difference between the In and OUT

If there is a time difference between the lastswipe and the currentr swipe is more than say 10 hrs.. then the current swipe should be obivously IN right!

Regards
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur,
Thanx for your time and reply,
The second point u told is very useful one, but the problem is
my client don't want to fix the shift schedule, they need less manual interaction with the software.

I have an idea, Can you provide your valuable suggestion for the following?
 My idea is fix one button in the reader for overnight punching
for eg: thos who working after 24.00 hrs will press key no: "1" and swipe, Then the particular punching will be considered as overnight punching and it will be calculated with the previous day.

I have already face this problem couple of days before...
you dont have any other option except compare the times with the shift timings it is the collection of condition nothing more...
check all the conditions....
:)
best of luck!!!!

DPK..