Calculate Work Time in Microsoft Access

Two hours and 30 minutes is 2.5 hours. Calculate minutes with DateDiff("n", [TimeIn], [TimeOut]), then divide by 60 for decimal hours you can total. The "n" means minutes; "m" means months. In my Total Time Spent video, I show how to calculate and display work time, then total it by job.

For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/1391.

Four Action Queries, Four Different Jobs

Need to change values, add records, remove records, or create a new table? Pick the action query that matches the job. This quick reference shows the four types and an important reminder: back up your database first. Watch the video for the overview.

For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/1550.