My.ADVISOR.com Sign-In
Username
Password
Sign Up 
Go to Article
Advanced Search 

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.
By Susan Sales Harkins

SUBSCRIBER-ONLY -- To read this article you must have a current Subscription or Passport for DATABASED ADVISOR or MICROSOFT ACCESS ADVISOR or MICROSOFT OFFICE ADVISOR or MICROSOFT PRO DEVELOPMENT ADVISOR. If you do, sign-in to view the complete article and access any Download. Click this link for details on how to activate your online access. You can purchase a Subscription or Passport at Advisor Store.

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.

Keyword Tags: Microsoft, Microsoft Access Development, Microsoft Office Access

ADVISORAMA
Opportunities are often missed because we are broadcasting when we should be listening.

ARTICLE INFO

DataBased Advisor

Web Edition: 2007 Week 36, Doc #19238

Print Edition: October 2007, Page 16

SUBSCRIBER ONLY ARTICLE LOCKED


 Article files are on this issue's Resource CD.
File: Get a file that contains the example table and queries in this article.
Subscribers, log-in for Download link.

Subscribe to FileMaker Advisor Magazine

Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

FileMaker.Advisor.com

Subscribe to Advisor Basics of FileMaker Pro

Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

FileMaker.AdvisorBasics.com

Showcase Your Smarts

Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

AdvisorTips.com

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Hosted by Prominic.NET Website powered by
LOTUS SOFTWARE
harks64 posted 09/04/2007 modified 08/19/2008 03:43:09 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 08/20/2008 01:53:44 AM