calculating time in attendance records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
single cell time entry as time - time; Ever seen this? 12
Access Access - Elapsed Time between Records 5
Time Grand Total 2
Percentages on time calculations 3
Calculating Elapsed Time 3
Calculate Time in A Report 5
calculate time elapsed inbetween days 3

Back
Top