How do your grand total minutes at the end of a report?

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

Guest

I have a column in my report that adds a start time and an end time column
and it gives it to me in minutes. When I try to create a grand total of the
total minutes at the end of the report, it will only give me the value of the
last record listed on the report. How can I correct this?
 
Try something like:
=Sum(DateDiff("n",[StartTime], [EndTime]))

If this doesn't work then perhaps you are not telling us something.
 
If you are trying to sum the difference between a pair of Date/Time fields
named StartTime and EndTime, put a text box in the Report Footer section and
give give it these properties:
ControlSource: =Sum(DateDiff("n", [StartTime], [EndTime]))
Format: General Number

For an explanation, see:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html
 
Back
Top