Good Morning,



I have a form that I am going to use to track employee time. A screen shot is attached along with sample database. I want to be able to add up time work.

End Time - Start Time = Time Work
Time Work - Break 1 Total - Break 2 Total - Lunch Total = Total Time Working

Problem I am running into is Access not being able to count time (or I not knowing the proper way to do it). I want to avoid my users from having to use 24-hr clock. I also understand this calculation should be done a in a query which is fine because I will be running reports based off that query. If it is possible to show the calculation on the form, that would be great as well.

Any suggestions?!?