Tracking Elapsed Time

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

Using Access 2000.

Have created a database to track how much time is spent on
projects on a given day.

User opens a form and selects the project and task they
are about to begin and then clicks a "timer" button which
stores current date and time in an unbound field on the
form. When the user is finished working on the project or
needs to change projects, they click the "timer" button
again which stores current date and time in a variable.

For instance, when button is clicked for the first time,
#2/5/2004 8:00:00 AM# is stored. When the button is
clicked the second time, #2/5/2004 1:15:00 PM# is stored.
I want the difference displayed and stored in a table. I
would prefer for the value too be stored as 5.25 hours but
can live with 5:15.

If the user comes back to this same project later in the
day, I want the total stored and displayed. For instance,
user starts at #2/5/2004 2:30 PM# and ends at #2/5/2004
4:00 PM#. I want the total time spent on that project for
that day to be 6.75 or 6:45.

I have some seen some time calculations posted but can't
seem to get them to do what I need.

Can anyone help?

Thanks,

Jerry
 
Back
Top