Time calculation formula in Access
Posted on 2009-05-06
I want to know if we have inbuilt facility/query for calculating hours worked for an employee during one day? Swipe in in morning: 07:00 and Swipe out: 18:00 evening. Total Hrs: 11 and less one Hour for Lunch. Hence Net Hours 10.
My another question is to convert time (mm:ss) into Number with rounding to 0.5
Swipe in : 07:10
Swipe Out: 17:35 then it should result into 9.5 hrs (After deducting 1 hour of lunch) and not 10