date/time field calculations

[donnan33]

I am trying to get the total hours for employees time daily.

I have the following fields as time fields (medium time) hours mins only.

starttime
timeout1
timein1
timeout2
timein2
finishtime

Not every time does the employee clock out 2 times but on occasion they do. When they do not those fields are left blank. I used the following to try to get the total hours. I get the correct time if the fileds are not left blank but when no time is entered into any field it does not calcualte right.

i used
starttime - 7am
timeout1 - 12 pm
time in1 - 1 pm
timeout2 - blank
timein2 - blank
finishtime - 4pm
should be total of 8 hours.

I used



Total Hours: nz(DateDiff("n",[starttime],[timeout1]),0)+nz(DateDiff("n",[timein1],[timeout2]),0)+nz(DateDiff("n",[timein2],[finishtime]),0)

this only returns total between startime and timout1......what can i do/change to get the total for all fields.

This is my first time using the date/time field as time. Any help is appreciated. Thanks

[bcofie]

Modify Total hours formule to:

iif([Starttime] is null OR [timeout] is null, "Whatever you wanna put here", nz(DateDiff("n",[starttime],[timeout1]),0)+nz(DateDiff("n",[timein1],[timeout2]),0)+nz(DateDiff("n",[timein2],[finishtime]),0) )

[donnan33]

I tried it out. I still get only the total from startime. timeout1..........

[bcofie]

post sample database.

[donnan33]

I got it now thanks anyway.