If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculation woes
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. |
#2
|
|||
|
|||
Calculation woes
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? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "JP6262AMY" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't Figure Out How To Do This Calculation - PLEASE HELP!! | Pat Hartman\(MVP\) | General Discussion | 0 | January 25th, 2006 05:43 PM |
Variable for holding a calculation for a text box | patentinv | General Discussion | 3 | October 9th, 2005 01:23 PM |
Calculation Setting in Excel | Stuart Bisset | General Discussion | 0 | June 17th, 2005 09:54 AM |
How do I use a rounded calculation result in another calculation? | vnsrod2000 | Worksheet Functions | 1 | January 26th, 2005 10:11 PM |
How do I use a rounded calculation result in another calculation? | vnsrod2000 | Worksheet Functions | 1 | January 26th, 2005 09:36 PM |