calculating time in attendance records

  • Thread starter Charles of Toowoomba
  • Start date
C

Charles of Toowoomba

My work involves managing a group of approx 15 clients. Most days I have
contact with only 4 at the most. I need to know how much time I spend on each
client during each day, and calculate total contact time over a 4-week
period. On the Access 2003 data entry form I can calculate the duration of
the contact by a simple expression - time end - time start = duration, (ie
09:12 - 08:45 = 00:27) but this simple calculation cannot be used in Query or
Report. The TimeElapsedString can calculate the elapsed time but I can't add
the elapsed time for each client.
It appears I have to become a wiz in VB do do this!
Can you help?
 
D

Duane Hookom

You can sum up minutes using an expression like:
DateDiff("n", [Start Time], [End Time])
This can be summed in a Report or Group Header or Footer using:
=Sum(DateDiff("n", [Start Time], [End Time]))
 
Top