Calculate Total Time Spent on a Job with DateDiff

In this Microsoft Access tutorial, I will teach you how to calculate the difference between two times. You can use this for employee time clocks, job costing, or just about any database where you need to figure out the difference between a start time and an end time in minutes and/or hours.

Adam from Fort Dodge, IA (a Developer Student) asks: I have a series of jobs that have a start date/time and an end date/time. I need to be able to calculate the total time worked on each job so I can bill my customers accordingly. Additionally, sometimes the job might start on a Thursday and end on a Monday. I need to exclude weekends, after hours (5pm to 8am the next day) and lunch breaks (noon to 1pm). How do I do this?

Members

I'll show you how to add ranges of time to exclude from your calculations (such as when the business is closed, lunch hour, breaks, etc.) and exclude weekends.

•  Extended Cut Video - Silver
•  Database Template Download - Gold

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!

Links

Difference in Dates: https://599cd.com/DifferenceInDates
Aggregate Queries: https://599cd.com/Aggregate
DateDiff Function: https://599cd.com/DateDiff
IIF Function: https://599cd.com/IIF
NetWorkDays: https://599cd.com/NetWorkDaysAccess

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.