I have a timesheet application that uses ms access as the db and I am having problems calculating the total time in the fields I used to capture the time they punched in.

these are the fields (time fields in access, no date)
TimeIn, TimeOut, LunchBeg, LunchEnd

How do I sum up the total amount of hours and minutes and put them into TotalTime (another field). Thanks.

This is what i've been trying:

mySQL_AT = "Select DateDiff('n', TimeIn, LunchBeg) As Tin, DateDiff('n', LunchEnd, TimeOut) As Tout From Emp_Hrs_Worked " _
& "Where workdate = #" & Date & "# And Socsec = '" & Session("frmUserid") & "'"

set rsAT = conntemp.Execute(mySQL_AT)
TT = rsAT("Tin") + rsAT("Tout")