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

If you're not a member, Join Today!Īccess Level 2 for just $1 Free Templates 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. Gold Members can download the database template from class plus get access to the Code Vault. Silver Members and up get access to view Extended Cut videos, when available. 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. I need to exclude weekends, after hours (5pm to 8am the next day) and lunch breaks (noon to 1pm). Additionally, sometimes the job might start on a Thursday and end on a Monday. I need to be able to calculate the total time worked on each job so I can bill my customers accordingly. The clock can also be used to teach about fractions and angles. Step by step learn about hours, minutes and seconds. Try a few free taster activities below and then head over to for over 600 interactive maths games and teaching tools Set the Clock. 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.Īdam 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. Simple to teach telling the time using a colourful classroom analog clock. Teaching Time - Telling the time made fun All the Teaching Time resources are now available as part of iR Online. In this Microsoft Access tutorial, I will teach you how to calculate the difference between two times.

Free teaching time clock calculator