Calculation of Time Cards of two shifts

[John Torres]

I created a form with “Time In1”, “Time Out1”, “Time In2”, “Time Out2”. I’m able to calculate the time correctly when it was during the day shifts from 7:00 AM (Time In1) 5:00 PM (Time Out1) = 10:00 but when the time goes over 12:00 AM it appears that it was totaled twice. Ex: 4:00 PM (Time In1), 12:00 AM (Time Out2)= 16:00
Here’s the calculation I used:
=NZ([Time Out1]-[Time In1])+NZ([Time Out2]-[Time In2])
Please help.
Thank you

[DonRayner]

Try using the datediff function instead

[John Torres]

Thank you. That works!!!