Time Calculations

[donnan33]

I have come across a problem i can't seem to fix. I have a database for recording employees hours like a time sheet. I have the following formula used to calculate the total hours worked per day. it works fine until they have time in all 6 fields?????

TotalHours: (Nz(DateDiff("n",[start time],Nz([time out1],nz([time out2],[finish time]))),0)+Nz(DateDiff("n",Nz([time in2],Nz([time in1],[start time])),[finish time]),0))/60 I have the following Start time time out1 time in1 time out2 time in2 finish time They seldom use all 6 but today someone did and it does not calculate properly. for the following times it totals only 4 hours when it should total 5. 7:05 am - 11:00am - 12:00 pm - 1:00 pm - 4:25 pm - 4:30 pm Can anyone help?

[June7]

The expression is calculating correctly as designed.

The first term result is 235 minutes. The second term result is only 5 minutes. Total 240 minutes = 4 hours.

You need to calculate sum of 3 terms (3 time periods), not 2.

[donnan33]

The expression is calculating correctly as designed.

The first term result is 235 minutes. The second term result is only 5 minutes. Total 240 minutes = 4 hours.

You need to calculate sum of 3 terms (3 time periods), not 2.

Can you help me with what I would need to add in the formula to make all 3 time periods? I have tried but can;t get it figured out...................To get the correct total of 5 hours?

[June7]

Maybe:

(Nz(DateDiff("n",[start time],Nz([time out1],nz([time out2],[finish time]))),0)+

Nz(DateDiff("n",[time in1],[time out2]),0)+

Nz(DateDiff("n",Nz([time in2],Nz([time in1],[start time])),[finish time]),0))/60