By Richard Rost 2 years ago
Calculating Total Hours for Employees, Billing, etc.
Learn how to create a timesheet in Microsoft Access. We will calculate the total hours and minutes for each line item, then calculate the total time worked in the form footer total.
Michelle from Dunedin, New Zealand (a Five Year Student) asks: I watched your video on calculating total time spent on a job, but how can I total that up in a form footer? I have a time sheet showing customers, a time in, and a time out. I'd like to calculate the total hours worked in the form footer.
Members will learn how to track which customer each entry is for by adding a customer combo box. We will also add notes, and a field to track whether or not each item has been invoiced. We will then create a button to add a new order to the invoicing system with one click. All of the items in the timesheet that have not yet been invoiced will be added to the order, and mark as invoiced. You can then print an invoice.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Total Time Spent: https://599cd.com/TimeSpent
Subscribe to Timesheets
Get notifications when this page is updated