13,090,678 members (47,877 online)
Rate this:
See more:
I develop the Rfid swiping machine project in that i have a problem that is i want to calculate the total working hours of each and Every Employee of based on first swipIn and last swipeOut .

pls help me....

Thanks & Regards

Venkat
Posted 10-Jul-13 20:55pm
Member 10014980 11-Jul-13 6:32am

The table Structor is like Below

Date,EmpName,EmpId,EMpRFID,SwipeIn,SwipeOut,Hours

i implements the Every time Swipe in and Swipeout Time and also hours of in between SwipeIn and Swipe out .
but i want first SwipeIn and Last SwipeOut for calculate total working hours in a day.

pls help me...
ArunRajendra 12-Jul-13 2:54am

Is your SwipeIn,SwipeOut just time or datetime?

Rate this:

## Solution 1

Try my previous post. The table structure might be different in you case. Can refine the answer if you post the table structure.

Calculation of Time in Sql Server 2008[^]
Member 10014980 12-Jul-13 2:46am

Thanks for response ....

he table Structor is like Below

Date,EmpName,EmpId,EMpRFID,SwipeIn,SwipeOut,Hours

i implements the Every time Swipe in and Swipeout Time and also hours of in between SwipeIn and Swipe out .
but i want first SwipeIn and Last SwipeOut for calculate total working hours in a day.

pls help me...
Rate this:

## Solution 2

The table Structor is like Below

Date,EmpName,EmpId,EMpRFID,SwipeIn,SwipeOut,Hours

i implements the Every time Swipe in and Swipeout Time and also hours of in between SwipeIn and Swipe out .
but i want first SwipeIn and Last SwipeOut for calculate total working hours in a day.

pls help me...

Top Experts
Last 24hrsThis month
 Graeme_Grant 130 RickZeeland 120 OriginalGriff 105 ppolymorphe 75 Wonde Tadesse 60
 OriginalGriff 3,462 Graeme_Grant 1,914 ProgramFOX 1,707 Jochen Arndt 1,645 ppolymorphe 1,552