EXPRESSIONS
Calculate and Total Elapsed Time in Microsoft Access
Tracking time spent on specific tasks is easy if you know how Access evaluates and formats time serial values.
Subscribers: Sign-in to activate download link -- Get a file that contains the example table and queries in this article.
About this Article:
Tracking time spent on specific tasks is vital if you're billing customers. However, billing doesn't have to be the primary goal. Simply tracking a job's progress can help you plan efficiently. For instance, knowing that a recurring task requires four hours helps you manage your own time. You might think that tracking just involves subtracting the time a task starts from the time it ends, but that's not always true. For instance, tasks that have the potential to extend into the next day (past midnight) need more help. Things get even more complicated when you sum elapsed time values to get grand totals. Fortunately, success is just a matter of applying the right expression. In this article, Susan gives you the tools you need to handle tasks that take two days or less.
Susan Sales Harkins is an independent consultant and the author of several articles and books on database technologies. Her most recent book is “Mastering Microsoft SQL Server 2005 Express,” with Mike Gunderloy, published by Sybex. Other collaborations with Mike Gunderloy are “Automating Microsoft Access 2003 with VBA,” “Upgrader’s Guide to Microsoft Office System 2003,” “ICDL Exam Cram 2,” and “Absolute Beginner's Guide to Microsoft Access 2003” all by Que. Currently, Susan volunteers as the Publications Director for Database Advisors at http://www.databaseadvisors.com. You can reach her at ssharkins at gmail.com.