Difference between two times
Posted on 2013-11-29
I am using DateDiff in Access 2010 to show the time difference between 2 times.
The above works fine, unless ClockOut time is after midnight, in which case I get a negative and inaccurate result.
Can anyone tell me how I need to modify this simple query so that when I run it I get the correct results.