Dale E. Reed Jr. wrote:
> Emerald rounds each call to your defined interval. Therefore, you
can't simply sum the AcctSessionTime
> values, or you will be under what Emerald calculates (Most likely by
the number of calls).
> How did you derive the above numbers? Are they from the Call History
table, or a query you ran?
I got the acctsessiontime from the calls table into an excel
spreadsheet.
Hours Online = AcctSessionTime / 3600
Minutes Billed = from the callhistory table
The CallHistory contains the following entries for the records shown
above. I have added the AcctSessionTime from the Calls table.
AccountID StartDate Months Mins
Calls ChargeID AcctSessionTime
----------- --------------------------- ----------- -----------
--------- ----------- -----------------
992 Jul 22 1999 12:00AM 1 1509
159 1408 137,964
1664 Jul 14 1999 7:58PM 1
675 29 (null) 150,389
2634 Jul 14 1999 7:58PM 1 1339
55 1456 165,530
3383 Jul 18 1999 12:00AM 1 8061
342 1518 1,176,051
Since Emerald rounds off each call to the defined interval, I suppose
I'm losing &/or gaining some time in the process. A smaller interval
will give more accurate figures?
If the interval is 3600 seconds, how will it round off the figures
listed below? I didn't quite understand how it works.
acctsessiontime
----------------
37
145
387
1355
535
2459
1468
Regards
Annabel
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart