<div>
Brilliant, works perfectly thank you!
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am using DateDiff in Access 2010 to show the time difference between 2 times.<br />
<br />
Minutes: DateDiff(&quot;n&quot;,[ClockInTime]<wbr />,[ClockOut<wbr />Time])<br />
<br />
The above works fine, unless ClockOut time is after midnight, in which case I get a negative and inaccurate result.<br />
<br />
Can anyone tell me how I need to modify this simple query so that when I run it I get the correct results.<br />
<br />
Thanks
</div>
</div>


Hi,

I am using DateDiff in Access 2010 to show the time difference between 2 times.

Minutes: DateDiff("n",[ClockInTime],[ClockOutTime])

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.

Thanks

Difference between two times

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.