Hi, I wish for some one to help me with the punch employee time calculation that is driving me nuts, the way I am currently calculating the hours worked is as followed
The Punch Clock capture the Employee Id and date and time clock in or out. (Multiple data rows)
Emp id Punched_Clock_In_Or_out Status
DOE001 2014-05-23 09:56:11 IN
DOE001 2014-05-23 18:07:03 OUT
Hours Worked = (Clock_Out - CLock_In) (18.07-9.56) = 8.51 but actually is 8 hours and 3 minutes
the others punched in/out time works great it just when there is punches like the mentioned above
does any one know or have a better formula to calculate the worked hours, I will really appreciate the help, I know my formula is not the best
TIA
Go to the complete details ...