calculation to get the number of hours worked

[rishi.luximon]

Hi Guys,

Actually i'm collecting data from a RFID reader and data shows the time in and out of employees. Normally if an employee works on a shift system the time in will be calculated time/date=X and time out will be time/date=Y that is two different dates. for example shift workers will have time in today at 6:00pm and time out tomorrow at 2:00am. can somebody tell me the calculation to get the number of hours worked for this employee or have a better idea how to proceed.

Thanks....... :D

[comment]

Answered here:

http://fmforums.com/forum/topic/78932-calculation-to-get-the-number-of-hours-worked

Please do not double post.