Add Time Diff

  • Thread starter Thread starter Sean McWherter
  • Start date Start date
S

Sean McWherter

Hello All. I need to know how i can sum the time differences access
gives me in my query. I'm using this formula to calculate the time
worked by an employee. TimeDiff:
Format([StartTime]-1-[EndTime],"Short Time") Now this figure is
shown in a report under the field TimeWorked. At the bottom of the
report, i want it to show the sum of all these "times worked" if you
will. Basically, someone might clock in and out 10 times a day, and
at the end of the week I want the report to simply show the amount of
time worked that week.
 
Put a textbox in the report's footer section, and set its control source to
this:

=Sum([TimeDiff])
 
Back
Top