Calculation woes

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

Guest

I have a form to enter help desk calls. We have one field with start time and
one with end time. Then we have a field to calculate the number of minutes
spent on each call. That field is called "Minutes".

In my monthly report, we detail the month's calls. Then we want a total of
the minutes. The expression we created was =Sum([Minutes])

For one month, the total was 298 minutes, but the expression returned
29.0416666666

What's up with that? Thanks.
 
What is Minutes?
Is it the name of a Date/Time field?
Is it a calculated expression in a query?
Is it a text box with an expression in its Control Source?

Where is this text box?
Is it in the Report Footer section?
In a Group Footer?
In a Page Footer?
 
Back
Top