Expression Help

[jcaptchaos2]

Hello,

I need some help with an expression I am finding the difference between 2 times using

Total: [Time Off]-[Time On]

That works well for 1st and 2nd shifts but 3rd shift starts at 10pm and is done at 6am so the result comes out wrong, in excel I use this code is there something in access like this?

=MOD(Q17-P17,1)

 

[Montez659]

JC,

Check out this link outlining the DateDiff function. It is what you are looking for.

http://www.techonthenet.com/access/functions/date/datediff.php

 

[jcaptchaos2]

Thanks Montez659